Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 WHERE t0.slug = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 WHERE t0.slug = '' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
ORDER BY
  t0.count DESC
LIMIT
  6

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 ORDER BY t0.count DESC LIMIT 6;

SELECT
  u0_.id AS id_0,
  u0_.remote_id AS remote_id_1,
  u0_.email AS email_2,
  u0_.gender AS gender_3,
  u0_.first_name AS first_name_4,
  u0_.last_name AS last_name_5,
  u0_.username AS username_6,
  u0_.hide_last_name AS hide_last_name_7,
  u0_.is_verified_email AS is_verified_email_8,
  u0_.phone_number AS phone_number_9,
  u0_.birth_date AS birth_date_10,
  u0_.avatar_hash AS avatar_hash_11,
  u0_.created_at AS created_at_12,
  u0_.rating_number AS rating_number_13,
  u0_.marketing_agreement AS marketing_agreement_14,
  u0_.rating_average AS rating_average_15,
  u0_.view_count AS view_count_16,
  u0_.roles AS roles_17,
  u0_.billing_address_id AS billing_address_id_18,
  u0_.about_me_id AS about_me_id_19
FROM
  `user` u0_
WHERE
  u0_.about_me_id IS NOT NULL
  AND u0_.avatar_hash IS NOT NULL
  AND u0_.is_verified_email = ?
ORDER BY
  u0_.rating_average DESC
LIMIT
  4

SELECT u0_.id AS id_0, u0_.remote_id AS remote_id_1, u0_.email AS email_2, u0_.gender AS gender_3, u0_.first_name AS first_name_4, u0_.last_name AS last_name_5, u0_.username AS username_6, u0_.hide_last_name AS hide_last_name_7, u0_.is_verified_email AS is_verified_email_8, u0_.phone_number AS phone_number_9, u0_.birth_date AS birth_date_10, u0_.avatar_hash AS avatar_hash_11, u0_.created_at AS created_at_12, u0_.rating_number AS rating_number_13, u0_.marketing_agreement AS marketing_agreement_14, u0_.rating_average AS rating_average_15, u0_.view_count AS view_count_16, u0_.roles AS roles_17, u0_.billing_address_id AS billing_address_id_18, u0_.about_me_id AS about_me_id_19 FROM `user` u0_ WHERE u0_.about_me_id IS NOT NULL AND u0_.avatar_hash IS NOT NULL AND u0_.is_verified_email = 1 ORDER BY u0_.rating_average DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.route AS route_2,
  t0.name AS name_3,
  t0.name_value AS name_value_4,
  t0.content_value AS content_value_5,
  t0.locale AS locale_6
FROM
  meta_tag t0
WHERE
  t0.route = ?
  AND t0.locale = ?

SELECT t0.id AS id_1, t0.route AS route_2, t0.name AS name_3, t0.name_value AS name_value_4, t0.content_value AS content_value_5, t0.locale AS locale_6 FROM meta_tag t0 WHERE t0.route = 'homepage' AND t0.locale = 'cs';

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.genitive_name AS genitive_name_3,
  s0_.icon AS icon_4,
  s0_.order_number AS order_number_5,
  s0_.count AS count_6
FROM
  subject s0_
ORDER BY
  s0_.order_number ASC,
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.genitive_name AS genitive_name_3, s0_.icon AS icon_4, s0_.order_number AS order_number_5, s0_.count AS count_6 FROM subject s0_ ORDER BY s0_.order_number ASC, s0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2,
  c0_.genitive_name AS genitive_name_3,
  c0_.order_number AS order_number_4,
  c0_.count AS count_5
FROM
  city c0_
ORDER BY
  c0_.order_number ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.genitive_name AS genitive_name_3, c0_.order_number AS order_number_4, c0_.count AS count_5 FROM city c0_ ORDER BY c0_.order_number ASC, c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
ORDER BY
  t0.count DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 ORDER BY t0.count DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.order_number AS order_number_5,
  t0.count AS count_6
FROM
  city t0
ORDER BY
  t0.count DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.order_number AS order_number_5, t0.count AS count_6 FROM city t0 ORDER BY t0.count DESC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  advert_place_attribute t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM advert_place_attribute t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.genitive_name AS genitive_name_4,
  t0.icon AS icon_5,
  t0.order_number AS order_number_6,
  t0.count AS count_7
FROM
  subject t0
ORDER BY
  t0.count DESC
LIMIT
  5

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.genitive_name AS genitive_name_4, t0.icon AS icon_5, t0.order_number AS order_number_6, t0.count AS count_7 FROM subject t0 ORDER BY t0.count DESC LIMIT 5;