Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception 1
• Logs 629
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• PHPCR
• Debug
• Emails
• Serializer
• JMS Serializer 0
• Sulu
• Configuration

Query Metrics

Queries

Group similar statements

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

[
  "muchmore-144"
]

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

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 = 'muchmore-144' LIMIT 1;

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 = ?

[
  144
]

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 = ?

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 = 144;

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

[
  144
]

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

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 = 144 LIMIT 5;

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

[
  1
  1
  1
  1
  1
  1
]

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

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 = 1 AND s1_.enabled = 1 AND u2_.enabled = 1 AND p3_.enabled = 1 AND u4_.active = 1 AND u4_.visible = 1 GROUP BY c0_.id ORDER BY c0_.priority DESC, c0_.size ASC;

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

[
  1
  1
  1
  1
  1
  1
]

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

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 = 1 AND s1_.enabled = 1 AND u2_.enabled = 1 AND c3_.enabled = 1 AND u4_.active = 1 AND u4_.visible = 1 GROUP BY p0_.id ORDER BY p0_.weeks ASC;

Database Connections

Entity Managers

Second Level Cache

Entities Mapping