Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.id_import AS id_import_2,
  t0.visible AS visible_3,
  t0.create_at AS create_at_4,
  t0.hidden_at AS hidden_at_5,
  t0.seo_slug AS seo_slug_6,
  t0.seo_title AS seo_title_7,
  t0.seo_description AS seo_description_8,
  t0.seo_h1 AS seo_h1_9,
  t0.url_generated_at AS url_generated_at_10,
  t0.vin AS vin_11,
  t0.places AS places_12,
  t0.doors AS doors_13,
  t0.load_capacity AS load_capacity_14,
  t0.total_weight AS total_weight_15,
  t0.state AS state_16,
  t0.mileage AS mileage_17,
  t0.mileage_unit AS mileage_unit_18,
  t0.made_date AS made_date_19,
  t0.price AS price_20,
  t0.vat AS vat_21,
  t0.price_before AS price_before_22,
  t0.price_leasing AS price_leasing_23,
  t0.payment_leasing_count AS payment_leasing_count_24,
  t0.eco_vat AS eco_vat_25,
  t0.engine_volume AS engine_volume_26,
  t0.stk_to AS stk_to_27,
  t0.first_owner AS first_owner_28,
  t0.service_book AS service_book_29,
  t0.tuning AS tuning_30,
  t0.note AS note_31,
  t0.engine_power AS engine_power_32,
  t0.type AS type_33,
  t0.not_crashed AS not_crashed_34,
  t0.financial_info AS financial_info_35,
  t0.payment_leasing AS payment_leasing_36,
  t0.gearbox AS gearbox_37,
  t0.category_id AS category_id_38,
  t0.kind_id AS kind_id_39,
  t0.sub_kind_id AS sub_kind_id_40,
  t0.model_id AS model_id_41,
  t0.body_id AS body_id_42,
  t0.color_id AS color_id_43,
  t0.fuel_id AS fuel_id_44,
  t0.condition_vehicle_id AS condition_vehicle_id_45,
  t0.part_kind_id AS part_kind_id_46,
  t0.manufacturer_id AS manufacturer_id_47,
  t48.id AS id_49,
  t48.create_at AS create_at_50,
  t48.end_at AS end_at_51,
  t48.vehicle_id AS vehicle_id_52,
  t0.dealer_id AS dealer_id_53
FROM
  vehicle t0
  LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.id_import AS id_import_2, t0.visible AS visible_3, t0.create_at AS create_at_4, t0.hidden_at AS hidden_at_5, t0.seo_slug AS seo_slug_6, t0.seo_title AS seo_title_7, t0.seo_description AS seo_description_8, t0.seo_h1 AS seo_h1_9, t0.url_generated_at AS url_generated_at_10, t0.vin AS vin_11, t0.places AS places_12, t0.doors AS doors_13, t0.load_capacity AS load_capacity_14, t0.total_weight AS total_weight_15, t0.state AS state_16, t0.mileage AS mileage_17, t0.mileage_unit AS mileage_unit_18, t0.made_date AS made_date_19, t0.price AS price_20, t0.vat AS vat_21, t0.price_before AS price_before_22, t0.price_leasing AS price_leasing_23, t0.payment_leasing_count AS payment_leasing_count_24, t0.eco_vat AS eco_vat_25, t0.engine_volume AS engine_volume_26, t0.stk_to AS stk_to_27, t0.first_owner AS first_owner_28, t0.service_book AS service_book_29, t0.tuning AS tuning_30, t0.note AS note_31, t0.engine_power AS engine_power_32, t0.type AS type_33, t0.not_crashed AS not_crashed_34, t0.financial_info AS financial_info_35, t0.payment_leasing AS payment_leasing_36, t0.gearbox AS gearbox_37, t0.category_id AS category_id_38, t0.kind_id AS kind_id_39, t0.sub_kind_id AS sub_kind_id_40, t0.model_id AS model_id_41, t0.body_id AS body_id_42, t0.color_id AS color_id_43, t0.fuel_id AS fuel_id_44, t0.condition_vehicle_id AS condition_vehicle_id_45, t0.part_kind_id AS part_kind_id_46, t0.manufacturer_id AS manufacturer_id_47, t48.id AS id_49, t48.create_at AS create_at_50, t48.end_at AS end_at_51, t48.vehicle_id AS vehicle_id_52, t0.dealer_id AS dealer_id_53 FROM vehicle t0 LEFT JOIN vehicle_tip t48 ON t48.vehicle_id = t0.id WHERE t0.id = 25932;

SELECT
  t0.id AS id_1,
  t0.day AS day_2,
  t0.summer AS summer_3,
  t0.description AS description_4,
  t0.dealer_id AS dealer_id_5
FROM
  dealer_open_hour t0
WHERE
  t0.dealer_id = ?
  AND t0.summer = ?

SELECT t0.id AS id_1, t0.day AS day_2, t0.summer AS summer_3, t0.description AS description_4, t0.dealer_id AS dealer_id_5 FROM dealer_open_hour t0 WHERE t0.dealer_id = 230 AND t0.summer = '0';

SELECT
  v0_.id AS id_0,
  v0_.id_import AS id_import_1,
  v0_.visible AS visible_2,
  v0_.create_at AS create_at_3,
  v0_.hidden_at AS hidden_at_4,
  v0_.seo_slug AS seo_slug_5,
  v0_.seo_title AS seo_title_6,
  v0_.seo_description AS seo_description_7,
  v0_.seo_h1 AS seo_h1_8,
  v0_.url_generated_at AS url_generated_at_9,
  v0_.vin AS vin_10,
  v0_.places AS places_11,
  v0_.doors AS doors_12,
  v0_.load_capacity AS load_capacity_13,
  v0_.total_weight AS total_weight_14,
  v0_.state AS state_15,
  v0_.mileage AS mileage_16,
  v0_.mileage_unit AS mileage_unit_17,
  v0_.made_date AS made_date_18,
  v0_.price AS price_19,
  v0_.vat AS vat_20,
  v0_.price_before AS price_before_21,
  v0_.price_leasing AS price_leasing_22,
  v0_.payment_leasing_count AS payment_leasing_count_23,
  v0_.eco_vat AS eco_vat_24,
  v0_.engine_volume AS engine_volume_25,
  v0_.stk_to AS stk_to_26,
  v0_.first_owner AS first_owner_27,
  v0_.service_book AS service_book_28,
  v0_.tuning AS tuning_29,
  v0_.note AS note_30,
  v0_.engine_power AS engine_power_31,
  v0_.type AS type_32,
  v0_.not_crashed AS not_crashed_33,
  v0_.financial_info AS financial_info_34,
  v0_.payment_leasing AS payment_leasing_35,
  v0_.gearbox AS gearbox_36,
  v0_.category_id AS category_id_37,
  v0_.kind_id AS kind_id_38,
  v0_.sub_kind_id AS sub_kind_id_39,
  v0_.model_id AS model_id_40,
  v0_.body_id AS body_id_41,
  v0_.color_id AS color_id_42,
  v0_.fuel_id AS fuel_id_43,
  v0_.condition_vehicle_id AS condition_vehicle_id_44,
  v0_.part_kind_id AS part_kind_id_45,
  v0_.manufacturer_id AS manufacturer_id_46,
  v0_.dealer_id AS dealer_id_47
FROM
  vehicle v0_
WHERE
  v0_.visible <> 0
  AND v0_.id <> ?
  AND v0_.body_id = ?
  AND v0_.dealer_id = ?
ORDER BY
  v0_.create_at DESC
LIMIT
  4

SELECT v0_.id AS id_0, v0_.id_import AS id_import_1, v0_.visible AS visible_2, v0_.create_at AS create_at_3, v0_.hidden_at AS hidden_at_4, v0_.seo_slug AS seo_slug_5, v0_.seo_title AS seo_title_6, v0_.seo_description AS seo_description_7, v0_.seo_h1 AS seo_h1_8, v0_.url_generated_at AS url_generated_at_9, v0_.vin AS vin_10, v0_.places AS places_11, v0_.doors AS doors_12, v0_.load_capacity AS load_capacity_13, v0_.total_weight AS total_weight_14, v0_.state AS state_15, v0_.mileage AS mileage_16, v0_.mileage_unit AS mileage_unit_17, v0_.made_date AS made_date_18, v0_.price AS price_19, v0_.vat AS vat_20, v0_.price_before AS price_before_21, v0_.price_leasing AS price_leasing_22, v0_.payment_leasing_count AS payment_leasing_count_23, v0_.eco_vat AS eco_vat_24, v0_.engine_volume AS engine_volume_25, v0_.stk_to AS stk_to_26, v0_.first_owner AS first_owner_27, v0_.service_book AS service_book_28, v0_.tuning AS tuning_29, v0_.note AS note_30, v0_.engine_power AS engine_power_31, v0_.type AS type_32, v0_.not_crashed AS not_crashed_33, v0_.financial_info AS financial_info_34, v0_.payment_leasing AS payment_leasing_35, v0_.gearbox AS gearbox_36, v0_.category_id AS category_id_37, v0_.kind_id AS kind_id_38, v0_.sub_kind_id AS sub_kind_id_39, v0_.model_id AS model_id_40, v0_.body_id AS body_id_41, v0_.color_id AS color_id_42, v0_.fuel_id AS fuel_id_43, v0_.condition_vehicle_id AS condition_vehicle_id_44, v0_.part_kind_id AS part_kind_id_45, v0_.manufacturer_id AS manufacturer_id_46, v0_.dealer_id AS dealer_id_47 FROM vehicle v0_ WHERE v0_.visible <> 0 AND v0_.id <> 25932 AND v0_.body_id = 3 AND v0_.dealer_id = 230 ORDER BY v0_.create_at DESC LIMIT 4;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.end_at AS end_at_3,
  t0.vehicle_id AS vehicle_id_4
FROM
  vehicle_tip t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = 38968;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.end_at AS end_at_3,
  t0.vehicle_id AS vehicle_id_4
FROM
  vehicle_tip t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = 38268;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.end_at AS end_at_3,
  t0.vehicle_id AS vehicle_id_4
FROM
  vehicle_tip t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = 36153;

SELECT
  t0.id AS id_1,
  t0.create_at AS create_at_2,
  t0.end_at AS end_at_3,
  t0.vehicle_id AS vehicle_id_4
FROM
  vehicle_tip t0
WHERE
  t0.vehicle_id = ?

SELECT t0.id AS id_1, t0.create_at AS create_at_2, t0.end_at AS end_at_3, t0.vehicle_id AS vehicle_id_4 FROM vehicle_tip t0 WHERE t0.vehicle_id = 32604;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.create_at AS create_at_4,
  t0.seo_filename AS seo_filename_5,
  t0.alt_text AS alt_text_6,
  t0.vehicle_id AS vehicle_id_7
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.main DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = 25932 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  vehicle_fuel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_body t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_body t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.auth_seller AS auth_seller_3,
  t0.city AS city_4,
  t0.street AS street_5,
  t0.check_vin AS check_vin_6,
  t0.visible AS visible_7,
  t0.basic_advertising AS basic_advertising_8,
  t0.email AS email_9,
  t0.www AS www_10,
  t0.description AS description_11,
  t0.lng AS lng_12,
  t0.lat AS lat_13,
  t0.rank AS rank_14,
  t0.logo AS logo_15,
  t0.import_id AS import_id_16,
  t0.name_import_vehicle AS name_import_vehicle_17,
  t0.id_import_vehicle AS id_import_vehicle_18,
  t0.url AS url_19,
  t0.opening_hours_note AS opening_hours_note_20,
  t0.district_id AS district_id_21
FROM
  dealer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.auth_seller AS auth_seller_3, t0.city AS city_4, t0.street AS street_5, t0.check_vin AS check_vin_6, t0.visible AS visible_7, t0.basic_advertising AS basic_advertising_8, t0.email AS email_9, t0.www AS www_10, t0.description AS description_11, t0.lng AS lng_12, t0.lat AS lat_13, t0.rank AS rank_14, t0.logo AS logo_15, t0.import_id AS import_id_16, t0.name_import_vehicle AS name_import_vehicle_17, t0.id_import_vehicle AS id_import_vehicle_18, t0.url AS url_19, t0.opening_hours_note AS opening_hours_note_20, t0.district_id AS district_id_21 FROM dealer t0 WHERE t0.id = 230;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  vehicle_color t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_color t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  vehicle_equipment t0
  INNER JOIN vehicle_vehicle_equipment ON t0.id = vehicle_vehicle_equipment.vehicle_equipment_id
WHERE
  vehicle_vehicle_equipment.vehicle_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_equipment t0 INNER JOIN vehicle_vehicle_equipment ON t0.id = vehicle_vehicle_equipment.vehicle_equipment_id WHERE vehicle_vehicle_equipment.vehicle_id = 25932;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4,
  t0.region_id AS region_id_5
FROM
  district t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.url AS url_4, t0.region_id AS region_id_5 FROM district t0 WHERE t0.id = 45;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.create_at AS create_at_4,
  t0.seo_filename AS seo_filename_5,
  t0.alt_text AS alt_text_6,
  t0.vehicle_id AS vehicle_id_7
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.main DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = 38968 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = 247;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 1508;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  vehicle_fuel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM vehicle_fuel t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.create_at AS create_at_4,
  t0.seo_filename AS seo_filename_5,
  t0.alt_text AS alt_text_6,
  t0.vehicle_id AS vehicle_id_7
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.main DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = 38268 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 107;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.create_at AS create_at_4,
  t0.seo_filename AS seo_filename_5,
  t0.alt_text AS alt_text_6,
  t0.vehicle_id AS vehicle_id_7
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.main DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = 36153 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = 182;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 1159;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.main AS main_3,
  t0.create_at AS create_at_4,
  t0.seo_filename AS seo_filename_5,
  t0.alt_text AS alt_text_6,
  t0.vehicle_id AS vehicle_id_7
FROM
  vehicle_image t0
WHERE
  t0.vehicle_id = ?
ORDER BY
  t0.main DESC,
  t0.id ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.create_at AS create_at_4, t0.seo_filename AS seo_filename_5, t0.alt_text AS alt_text_6, t0.vehicle_id AS vehicle_id_7 FROM vehicle_image t0 WHERE t0.vehicle_id = 32604 ORDER BY t0.main DESC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3
FROM
  vehicle_manufacturer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM vehicle_manufacturer t0 WHERE t0.id = 197;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 1275;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4
FROM
  vehicle_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.vehicle_manufacturer_id AS vehicle_manufacturer_id_4 FROM vehicle_model t0 WHERE t0.id = 109;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.dealer_id AS dealer_id_3
FROM
  dealer_phone t0
WHERE
  t0.dealer_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.dealer_id AS dealer_id_3 FROM dealer_phone t0 WHERE t0.dealer_id = 230;

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 1 ORDER BY t0.rank ASC;

SELECT
  t0.id AS id_1,
  t0.rank AS rank_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.visible AS visible_5,
  t0.main AS main_6,
  t0.title AS title_7,
  t0.description AS description_8,
  t0.text AS text_9
FROM
  page t0
WHERE
  t0.visible = ?
  AND t0.main = ?
ORDER BY
  t0.rank ASC

SELECT t0.id AS id_1, t0.rank AS rank_2, t0.name AS name_3, t0.url AS url_4, t0.visible AS visible_5, t0.main AS main_6, t0.title AS title_7, t0.description AS description_8, t0.text AS text_9 FROM page t0 WHERE t0.visible = 1 AND t0.main = 0 ORDER BY t0.rank ASC;