GET https://gzedev.mm-service.pl/dostawcy/voyager-143

Query Metrics

7 Database Queries
7 Different statements
191.37 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 27.49 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nip AS nip_5, t0.phone_number AS phone_number_6, t0.consent AS consent_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.confirmed_at AS confirmed_at_11, t0.activation_token AS activation_token_12, t0.logo_url AS logo_url_13, t0.name AS name_14, t0.slug AS slug_15, t0.bio AS bio_16, t0.bio2 AS bio2_17, t0.express_hour AS express_hour_18, t0.postal_code AS postal_code_19, t0.city AS city_20, t0.street AS street_21, t0.visible AS visible_22, t0.contact_person AS contact_person_23, t0.service_terms_accepted AS service_terms_accepted_24, t0.personal_data_processing_consent AS personal_data_processing_consent_25, t0.commission AS commission_26, t0.transport_terms AS transport_terms_27, t0.fixed_commission AS fixed_commission_28, t0.fixed_commission_prolong AS fixed_commission_prolong_29, t0.first_commission_fixed AS first_commission_fixed_30, t0.fixed_commission_express AS fixed_commission_express_31, t0.transport_terms_updated_at AS transport_terms_updated_at_32, t0.last_login AS last_login_33, t0.bdo_company_name AS bdo_company_name_34, t0.bdo_register_number AS bdo_register_number_35, t0.bdo_location AS bdo_location_36, t0.mpd_number AS mpd_number_37, t0.bdo_number AS bdo_number_38 FROM user t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "voyager-143"
]
2 27.22 ms
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.rating AS rating_3, o0_.nick AS nick_4, o0_.opinion AS opinion_5, o0_.answer AS answer_6, o0_.order_entity_id AS order_entity_id_7, o0_.user_id AS user_id_8 FROM opinion o0_ WHERE o0_.user_id = ?
Parameters:
[
  143
]
3 27.29 ms
SELECT o0_.id AS id_0, o0_.created_at AS created_at_1, o0_.updated_at AS updated_at_2, o0_.rating AS rating_3, o0_.nick AS nick_4, o0_.opinion AS opinion_5, o0_.answer AS answer_6, o0_.order_entity_id AS order_entity_id_7, o0_.user_id AS user_id_8 FROM opinion o0_ WHERE o0_.user_id = ? LIMIT 5
Parameters:
[
  143
]
4 27.67 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_pl AS name_pl_2, c0_.size AS size_3, c0_.enabled AS enabled_4, c0_.priority AS priority_5 FROM container_size c0_ INNER JOIN service s1_ ON c0_.id = s1_.container_size_id INNER JOIN user_service u2_ ON s1_.id = u2_.service_id INNER JOIN period p3_ ON s1_.period_id = p3_.id LEFT JOIN user u4_ ON u2_.user_id = u4_.id WHERE c0_.enabled = ? AND s1_.enabled = ? AND u2_.enabled = ? AND p3_.enabled = ? AND u4_.active = ? AND u4_.visible = ? GROUP BY c0_.id ORDER BY c0_.priority DESC, c0_.size ASC
Parameters:
[
  1
  1
  1
  1
  1
  1
]
5 27.55 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.weeks AS weeks_2, p0_.enabled AS enabled_3 FROM period p0_ INNER JOIN service s1_ ON p0_.id = s1_.period_id INNER JOIN user_service u2_ ON s1_.id = u2_.service_id INNER JOIN container_size c3_ ON s1_.container_size_id = c3_.id LEFT JOIN user u4_ ON u2_.user_id = u4_.id WHERE p0_.enabled = ? AND s1_.enabled = ? AND u2_.enabled = ? AND c3_.enabled = ? AND u4_.active = ? AND u4_.visible = ? GROUP BY p0_.id ORDER BY p0_.weeks ASC
Parameters:
[
  1
  1
  1
  1
  1
  1
]
6 27.05 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.rating AS rating_4, t0.nick AS nick_5, t0.opinion AS opinion_6, t0.answer AS answer_7, t0.order_entity_id AS order_entity_id_8, t0.user_id AS user_id_9 FROM opinion t0 WHERE t0.user_id = ?
Parameters:
[
  143
]
7 27.10 ms
SELECT w0_.title AS title_0, w0_.webspace_key AS webspace_key_1, w0_.all_domains AS all_domains_2, w0_.content AS content_3, w0_.type AS type_4, w0_.id AS id_5, w1_.url AS url_6, w1_.environment AS environment_7, w1_.id AS id_8 FROM we_analytics w0_ LEFT JOIN we_analytics_domains w2_ ON w0_.id = w2_.analytics LEFT JOIN we_domains w1_ ON w1_.id = w2_.domain WHERE (w0_.all_domains = 1 OR (w1_.url = ? AND w1_.environment = ?)) AND w0_.webspace_key = ? ORDER BY w0_.id ASC
Parameters:
[
  "gzedev.mm-service.pl"
  "dev"
  "wywoz_gruzu"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Sulu\Bundle\TrashBundle\Domain\Model\TrashItem No errors.
Sulu\Bundle\MediaBundle\Entity\Collection No errors.
Sulu\Bundle\ContactBundle\Entity\ContactTitle No errors.
Sulu\Bundle\SecurityBundle\Entity\Group No errors.
App\Entity\Opinion No errors.
App\Entity\User No errors.
App\Entity\AreaCommunity No errors.
App\Entity\UserService No errors.
App\Entity\ChangePasswordRequest No errors.
App\Entity\Report No errors.
App\Entity\Order No errors.
App\Entity\ContainerSize No errors.
App\Entity\Service No errors.
App\Entity\Period No errors.
Sulu\Bundle\WebsiteBundle\Entity\Analytics No errors.
Sulu\Bundle\WebsiteBundle\Entity\Domain No errors.