Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.language AS language_4,
  t0.comment AS comment_5,
  t0.code AS code_6
FROM
  trading_platform t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.language AS language_4, t0.comment AS comment_5, t0.code AS code_6 FROM trading_platform t0 WHERE t0.code = 'dongchedi' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.name_origin AS name_origin_2,
  m0_.mark_inner_id AS mark_inner_id_3,
  m0_.mark_inner_str AS mark_inner_str_4,
  m0_.mark_origin_extra AS mark_origin_extra_5,
  m0_.trading_platform_id AS trading_platform_id_6,
  m0_.mark_id AS mark_id_7
FROM
  mark_origin m0_
WHERE
  m0_.trading_platform_id = ?
  AND (
    (
      LOWER(m0_.name_origin) = LOWER(?)
      OR LOWER(m0_.name) = LOWER(?)
    )
  )
LIMIT
  1

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.name_origin AS name_origin_2, m0_.mark_inner_id AS mark_inner_id_3, m0_.mark_inner_str AS mark_inner_str_4, m0_.mark_origin_extra AS mark_origin_extra_5, m0_.trading_platform_id AS trading_platform_id_6, m0_.mark_id AS mark_id_7 FROM mark_origin m0_ WHERE m0_.trading_platform_id = 1 AND ((LOWER(m0_.name_origin) = LOWER('BYD') OR LOWER(m0_.name) = LOWER('BYD'))) LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.generation AS generation_1,
  o0_.configuration AS configuration_2,
  o0_.complectation AS complectation_3,
  o0_.color AS color_4,
  o0_.year AS year_5,
  o0_.mileage AS mileage_6,
  o0_.engine_type AS engine_type_7,
  o0_.engine_displacement AS engine_displacement_8,
  o0_.transmission_type AS transmission_type_9,
  o0_.url AS url_10,
  o0_.inner_id AS inner_id_11,
  o0_.price AS price_12,
  o0_.price_full AS price_full_13,
  o0_.address AS address_14,
  o0_.currency AS currency_15,
  o0_.description AS description_16,
  o0_.date_offer AS date_offer_17,
  o0_.date_add AS date_add_18,
  o0_.date_update AS date_update_19,
  o0_.options AS options_20,
  o0_.extra AS extra_21,
  o0_.city_name AS city_name_22,
  o0_.dealer_name AS dealer_name_23,
  o0_.dealer_full AS dealer_full_24,
  o0_.trading_platform_id AS trading_platform_id_25,
  o0_.mark_origin_id AS mark_origin_id_26,
  o0_.model_origin_id AS model_origin_id_27,
  o0_.body_origin_id AS body_origin_id_28,
  o0_.country_id AS country_id_29,
  o0_.city_id AS city_id_30,
  o0_.seller_id AS seller_id_31
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?
  AND o0_.year >= ?
  AND o0_.year <= ?
  AND o0_.mileage >= ?
  AND o0_.mileage <= ?
  AND o0_.price >= ?
  AND o0_.price <= ?
  AND o0_.date_offer >= ?
  AND o0_.date_offer <= ?
  AND o0_.engine_displacement >= ?
  AND o0_.engine_displacement <= ?
  AND o0_.mark_origin_id = ?
LIMIT
  20

SELECT o0_.id AS id_0, o0_.generation AS generation_1, o0_.configuration AS configuration_2, o0_.complectation AS complectation_3, o0_.color AS color_4, o0_.year AS year_5, o0_.mileage AS mileage_6, o0_.engine_type AS engine_type_7, o0_.engine_displacement AS engine_displacement_8, o0_.transmission_type AS transmission_type_9, o0_.url AS url_10, o0_.inner_id AS inner_id_11, o0_.price AS price_12, o0_.price_full AS price_full_13, o0_.address AS address_14, o0_.currency AS currency_15, o0_.description AS description_16, o0_.date_offer AS date_offer_17, o0_.date_add AS date_add_18, o0_.date_update AS date_update_19, o0_.options AS options_20, o0_.extra AS extra_21, o0_.city_name AS city_name_22, o0_.dealer_name AS dealer_name_23, o0_.dealer_full AS dealer_full_24, o0_.trading_platform_id AS trading_platform_id_25, o0_.mark_origin_id AS mark_origin_id_26, o0_.model_origin_id AS model_origin_id_27, o0_.body_origin_id AS body_origin_id_28, o0_.country_id AS country_id_29, o0_.city_id AS city_id_30, o0_.seller_id AS seller_id_31 FROM offer o0_ WHERE o0_.trading_platform_id = 1 AND o0_.year >= 2008 AND o0_.year <= 2010 AND o0_.mileage >= 0 AND o0_.mileage <= 999999 AND o0_.price >= 8500 AND o0_.price <= 4958000 AND o0_.date_offer >= '2026-01-01 00:00:00' AND o0_.date_offer <= '2999-01-01 00:00:00' AND o0_.engine_displacement >= 0 AND o0_.engine_displacement <= 99999 AND o0_.mark_origin_id = 390 LIMIT 20;

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  offer o0_
WHERE
  o0_.trading_platform_id = ?
  AND o0_.year >= ?
  AND o0_.year <= ?
  AND o0_.mileage >= ?
  AND o0_.mileage <= ?
  AND o0_.price >= ?
  AND o0_.price <= ?
  AND o0_.date_offer >= ?
  AND o0_.date_offer <= ?
  AND o0_.engine_displacement >= ?
  AND o0_.engine_displacement <= ?
  AND o0_.mark_origin_id = ?

SELECT COUNT(o0_.id) AS sclr_0 FROM offer o0_ WHERE o0_.trading_platform_id = 1 AND o0_.year >= 2008 AND o0_.year <= 2010 AND o0_.mileage >= 0 AND o0_.mileage <= 999999 AND o0_.price >= 8500 AND o0_.price <= 4958000 AND o0_.date_offer >= '2026-01-01 00:00:00' AND o0_.date_offer <= '2999-01-01 00:00:00' AND o0_.engine_displacement >= 0 AND o0_.engine_displacement <= 99999 AND o0_.mark_origin_id = 390;