Symfony Profiler

SELECT
  t1.id AS id_2,
  t1.uuid AS uuid_3,
  t1.approve_status AS approve_status_4,
  t1.visibility_status AS visibility_status_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t1.expire_at AS expire_at_8,
  t1.deleted_at AS deleted_at_9,
  t1.ip_address AS ip_address_10,
  t1.view_count AS view_count_11,
  t1.score AS score_12,
  t0.title AS title_13,
  t0.slug AS slug_14,
  t0.brief AS brief_15,
  t0.description AS description_16,
  t0.price AS price_17,
  t0.price_alternative AS price_alternative_18,
  t0.price_time AS price_time_19,
  t1.user_id AS user_id_20,
  t0.subject_id AS subject_id_21,
  t1.type
FROM
  advert_offer t0
  INNER JOIN content_item t1 ON t0.id = t1.id
WHERE
  t1.ip_address = ?
  AND t1.visibility_status = ?
LIMIT
  1

SELECT t1.id AS id_2, t1.uuid AS uuid_3, t1.approve_status AS approve_status_4, t1.visibility_status AS visibility_status_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t1.expire_at AS expire_at_8, t1.deleted_at AS deleted_at_9, t1.ip_address AS ip_address_10, t1.view_count AS view_count_11, t1.score AS score_12, t0.title AS title_13, t0.slug AS slug_14, t0.brief AS brief_15, t0.description AS description_16, t0.price AS price_17, t0.price_alternative AS price_alternative_18, t0.price_time AS price_time_19, t1.user_id AS user_id_20, t0.subject_id AS subject_id_21, t1.type FROM advert_offer t0 INNER JOIN content_item t1 ON t0.id = t1.id WHERE t1.ip_address = '3.12.150.240' AND t1.visibility_status = 2 LIMIT 1;

SELECT
  a0_.order_number AS order_number_0,
  a0_.id AS id_1,
  a0_.name AS name_2,
  a0_.slug AS slug_3
FROM
  advert_level a0_
ORDER BY
  a0_.order_number DESC

SELECT a0_.order_number AS order_number_0, a0_.id AS id_1, a0_.name AS name_2, a0_.slug AS slug_3 FROM advert_level a0_ ORDER BY a0_.order_number DESC;

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.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 = 'advert_offer_add' AND t0.locale = 'sk';

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