Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.city_id AS city_id_4,
  t0.county_id AS county_id_5,
  t0.district_id AS district_id_6
FROM
  city_stations t0
WHERE
  t0.city_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.city_id AS city_id_4, t0.county_id AS county_id_5, t0.district_id AS district_id_6 FROM city_stations t0 WHERE t0.city_id = 1 ORDER BY t0.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.uri AS uri_1,
  p0_.top_html AS top_html_2,
  p0_.bottom_html AS bottom_html_3,
  p0_.meta_title AS meta_title_4,
  p0_.meta_description AS meta_description_5,
  p0_.meta_keywords AS meta_keywords_6,
  p0_.page_heading AS page_heading_7,
  p0_.city_id AS city_id_8
FROM
  page_seo_texts p0_
WHERE
  p0_.uri = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.uri AS uri_1, p0_.top_html AS top_html_2, p0_.bottom_html AS bottom_html_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.meta_keywords AS meta_keywords_6, p0_.page_heading AS page_heading_7, p0_.city_id AS city_id_8 FROM page_seo_texts p0_ WHERE p0_.uri = '/remind/' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nick_name AS nick_name_3,
  t0.notes AS notes_4,
  t0.country_code AS country_code_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.confirmation_code AS confirmation_code_8,
  t0.smsc_code AS smsc_code_9,
  t0.enabled AS enabled_10,
  t0.trusted AS trusted_11,
  t0.credits AS credits_12,
  t0.currency_code AS currency_code_13,
  t0.full_registered AS full_registered_14,
  t0.post_registration_step AS post_registration_step_15,
  t0.created AS created_16,
  t0.updated AS updated_17,
  t0.balance_low_notified_at AS balance_low_notified_at_18,
  t0.ban AS ban_19,
  t0.city_id AS city_id_20,
  t22.id AS id_21,
  t22.path AS path_23,
  t22.user_id AS user_id_24,
  t25.account_id AS account_id_26,
  t0.type
FROM
  user t0
  LEFT JOIN user_media_files t22 ON t22.user_id = t0.id
  LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id
WHERE
  t0.email IS NULL
  AND t0.type IN ('advertiser', 'customer')
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.nick_name AS nick_name_3, t0.notes AS notes_4, t0.country_code AS country_code_5, t0.roles AS roles_6, t0.password AS password_7, t0.confirmation_code AS confirmation_code_8, t0.smsc_code AS smsc_code_9, t0.enabled AS enabled_10, t0.trusted AS trusted_11, t0.credits AS credits_12, t0.currency_code AS currency_code_13, t0.full_registered AS full_registered_14, t0.post_registration_step AS post_registration_step_15, t0.created AS created_16, t0.updated AS updated_17, t0.balance_low_notified_at AS balance_low_notified_at_18, t0.ban AS ban_19, t0.city_id AS city_id_20, t22.id AS id_21, t22.path AS path_23, t22.user_id AS user_id_24, t25.account_id AS account_id_26, t0.type FROM user t0 LEFT JOIN user_media_files t22 ON t22.user_id = t0.id LEFT JOIN account_offer_bar_hidden t25 ON t25.account_id = t0.id WHERE t0.email IS NULL AND t0.type IN ('advertiser', 'customer') LIMIT 1;

SELECT
  p0_.city_id AS sclr_0,
  COUNT(p0_.id) AS sclr_1
FROM
  profiles p0_
  INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id
WHERE
  (
    p0_.person_gender IN (?)
    AND p0_.moderation_status IN (?, ?, ?)
  )
  AND (p0_.deleted_at IS NULL)
GROUP BY
  p0_.city_id

SELECT p0_.city_id AS sclr_0, COUNT(p0_.id) AS sclr_1 FROM profiles p0_ INNER JOIN profile_adboard_placements p1_ ON p0_.id = p1_.profile_id WHERE (p0_.person_gender IN (1) AND p0_.moderation_status IN (0, 2, 1)) AND (p0_.deleted_at IS NULL) GROUP BY p0_.city_id;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.uri_identity AS uri_identity_2,
  c0_.country_code AS country_code_3,
  c0_.city_group AS city_group_4,
  c0_.timezone AS timezone_5,
  c0_.map_latitude AS map_latitude_6,
  c0_.map_longitude AS map_longitude_7
FROM
  cities c0_
WHERE
  c0_.uri_identity = ?
LIMIT
  1

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.uri_identity AS uri_identity_2, c0_.country_code AS country_code_3, c0_.city_group AS city_group_4, c0_.timezone AS timezone_5, c0_.map_latitude AS map_latitude_6, c0_.map_longitude AS map_longitude_7 FROM cities c0_ WHERE c0_.uri_identity = 'moscow' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.uri_identity AS uri_identity_3,
  t0.country_code AS country_code_4,
  t0.city_group AS city_group_5,
  t0.timezone AS timezone_6,
  t0.map_latitude AS map_latitude_7,
  t0.map_longitude AS map_longitude_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.uri_identity AS uri_identity_3, t0.country_code AS country_code_4, t0.city_group AS city_group_5, t0.timezone AS timezone_6, t0.map_latitude AS map_latitude_7, t0.map_longitude AS map_longitude_8 FROM cities t0;