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
  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
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  advert_place_attribute a0_
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_place_attribute a0_ ORDER BY a0_.id DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  advert_preferred_time_attribute a0_
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_preferred_time_attribute a0_ ORDER BY a0_.id DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  advert_teacher_experience_attribute a0_
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_teacher_experience_attribute a0_ ORDER BY a0_.id DESC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  advert_other_attribute a0_
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM advert_other_attribute a0_ ORDER BY a0_.id DESC;

SELECT
  c0_.id AS id_0,
  c0_.uuid AS uuid_1,
  c0_.approve_status AS approve_status_2,
  c0_.visibility_status AS visibility_status_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.expire_at AS expire_at_6,
  c0_.deleted_at AS deleted_at_7,
  c0_.ip_address AS ip_address_8,
  c0_.view_count AS view_count_9,
  c0_.score AS score_10,
  a1_.description AS description_11,
  a1_.student_count AS student_count_12,
  a1_.lection_count AS lection_count_13,
  a1_.preferred_gender AS preferred_gender_14,
  a1_.demand_duration AS demand_duration_15,
  c0_.type AS type_16,
  c0_.user_id AS user_id_17,
  a1_.subject_id AS subject_id_18,
  a1_.level_id AS level_id_19
FROM
  advert_demand a1_
  INNER JOIN content_item c0_ ON a1_.id = c0_.id
WHERE
  c0_.visibility_status = ?
  AND c0_.approve_status IN (?)
ORDER BY
  c0_.created_at DESC
LIMIT
  20

SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.approve_status AS approve_status_2, c0_.visibility_status AS visibility_status_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.expire_at AS expire_at_6, c0_.deleted_at AS deleted_at_7, c0_.ip_address AS ip_address_8, c0_.view_count AS view_count_9, c0_.score AS score_10, a1_.description AS description_11, a1_.student_count AS student_count_12, a1_.lection_count AS lection_count_13, a1_.preferred_gender AS preferred_gender_14, a1_.demand_duration AS demand_duration_15, c0_.type AS type_16, c0_.user_id AS user_id_17, a1_.subject_id AS subject_id_18, a1_.level_id AS level_id_19 FROM advert_demand a1_ INNER JOIN content_item c0_ ON a1_.id = c0_.id WHERE c0_.visibility_status = 1 AND c0_.approve_status IN (1, 2) ORDER BY c0_.created_at DESC LIMIT 20;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  advert_demand a1_
  INNER JOIN content_item c0_ ON a1_.id = c0_.id
WHERE
  c0_.visibility_status = ?
  AND c0_.approve_status IN (?)
ORDER BY
  c0_.created_at DESC

SELECT COUNT(c0_.id) AS sclr_0 FROM advert_demand a1_ INNER JOIN content_item c0_ ON a1_.id = c0_.id WHERE c0_.visibility_status = 1 AND c0_.approve_status IN (1, 2) ORDER BY c0_.created_at 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_demand_list' AND t0.locale = 'cs';

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 16;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 15;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 15;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 14;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 12;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 12;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 14;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 11;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 8;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 6;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.email AS email_3,
  t0.gender AS gender_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.username AS username_7,
  t0.hide_last_name AS hide_last_name_8,
  t0.is_verified_email AS is_verified_email_9,
  t0.phone_number AS phone_number_10,
  t0.birth_date AS birth_date_11,
  t0.avatar_hash AS avatar_hash_12,
  t0.created_at AS created_at_13,
  t0.rating_number AS rating_number_14,
  t0.marketing_agreement AS marketing_agreement_15,
  t0.rating_average AS rating_average_16,
  t0.view_count AS view_count_17,
  t0.roles AS roles_18,
  t0.billing_address_id AS billing_address_id_19,
  t0.about_me_id AS about_me_id_20
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.email AS email_3, t0.gender AS gender_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.username AS username_7, t0.hide_last_name AS hide_last_name_8, t0.is_verified_email AS is_verified_email_9, t0.phone_number AS phone_number_10, t0.birth_date AS birth_date_11, t0.avatar_hash AS avatar_hash_12, t0.created_at AS created_at_13, t0.rating_number AS rating_number_14, t0.marketing_agreement AS marketing_agreement_15, t0.rating_average AS rating_average_16, t0.view_count AS view_count_17, t0.roles AS roles_18, t0.billing_address_id AS billing_address_id_19, t0.about_me_id AS about_me_id_20 FROM `user` t0 WHERE t0.id = 10;

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
  INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id
WHERE
  advert_demand_city.advert_demand_id = ?

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 INNER JOIN advert_demand_city ON t0.id = advert_demand_city.city_id WHERE advert_demand_city.advert_demand_id = 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.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,
  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;