Symfony Profiler

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.auth_seller AS auth_seller_2,
  d0_.city AS city_3,
  d0_.street AS street_4,
  d0_.check_vin AS check_vin_5,
  d0_.visible AS visible_6,
  d0_.basic_advertising AS basic_advertising_7,
  d0_.email AS email_8,
  d0_.www AS www_9,
  d0_.description AS description_10,
  d0_.lng AS lng_11,
  d0_.lat AS lat_12,
  d0_.rank AS rank_13,
  d0_.logo AS logo_14,
  d0_.import_id AS import_id_15,
  d0_.name_import_vehicle AS name_import_vehicle_16,
  d0_.id_import_vehicle AS id_import_vehicle_17,
  d0_.id_export_cars AS id_export_cars_18,
  d0_.url AS url_19,
  d0_.opening_hours_note AS opening_hours_note_20,
  d0_.district_id AS district_id_21
FROM
  dealer d0_
WHERE
  d0_.visible = ?
  AND (
    (
      d0_.basic_advertising IS NULL
      OR d0_.basic_advertising = 0
    )
  )
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.auth_seller AS auth_seller_2, d0_.city AS city_3, d0_.street AS street_4, d0_.check_vin AS check_vin_5, d0_.visible AS visible_6, d0_.basic_advertising AS basic_advertising_7, d0_.email AS email_8, d0_.www AS www_9, d0_.description AS description_10, d0_.lng AS lng_11, d0_.lat AS lat_12, d0_.rank AS rank_13, d0_.logo AS logo_14, d0_.import_id AS import_id_15, d0_.name_import_vehicle AS name_import_vehicle_16, d0_.id_import_vehicle AS id_import_vehicle_17, d0_.id_export_cars AS id_export_cars_18, d0_.url AS url_19, d0_.opening_hours_note AS opening_hours_note_20, d0_.district_id AS district_id_21 FROM dealer d0_ WHERE d0_.visible = '1' AND ((d0_.basic_advertising IS NULL OR d0_.basic_advertising = 0)) ORDER BY d0_.name ASC;

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.id_export_cars AS id_export_cars_19,
  t0.url AS url_20,
  t0.opening_hours_note AS opening_hours_note_21,
  t0.district_id AS district_id_22
FROM
  dealer t0
WHERE
  t0.visible = ?
ORDER BY
  t0.name ASC

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.id_export_cars AS id_export_cars_19, t0.url AS url_20, t0.opening_hours_note AS opening_hours_note_21, t0.district_id AS district_id_22 FROM dealer t0 WHERE t0.visible = '1' ORDER BY t0.name ASC;

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 3;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 419 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 2;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 179 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 12;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 347 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 14;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 340 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 337 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 189 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 370 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 443 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 205 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 6;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 268 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 269 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 5;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 270 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 271 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 4;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 191 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 339 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 174 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 346 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 383 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 13;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 308 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 377 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 15;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 435 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 380 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 263 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 258 AND t0.visible = '1';

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

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.url AS url_4
FROM
  region 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 FROM region t0 WHERE t0.id = 11;

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 289 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 290 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 359 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 336 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 227 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 291 AND t0.visible = '1';

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

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 217 AND t0.visible = '1';

SELECT
  COUNT(*)
FROM
  vehicle t0
WHERE
  t0.dealer_id = ?
  AND t0.visible = ?

SELECT COUNT(*) FROM vehicle t0 WHERE t0.dealer_id = 343 AND t0.visible = '1';