Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.email = '[email protected]' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.md5_hash AS md5_hash_3,
  t0.location AS location_4,
  t0.direction AS direction_5,
  t0.dimensions AS dimensions_6,
  t0.lighting AS lighting_7,
  t0.rent_per_month AS rent_per_month_8,
  t0.print_and_mount AS print_and_mount_9,
  t0.province AS province_10,
  t0.google_map_url AS google_map_url_11,
  t0.video_url AS video_url_12,
  t0.lat_lang AS lat_lang_13,
  t0.description AS description_14,
  t0.photo_url AS photo_url_15,
  t0.blocked_to AS blocked_to_16,
  t0.blocked_from AS blocked_from_17,
  t0.last_export_date AS last_export_date_18,
  t0.categories AS categories_19,
  t0.main_photo AS main_photo_20,
  t0.gallery AS gallery_21,
  t0.monthly_reach AS monthly_reach_22,
  t0.updated_at AS updated_at_23,
  t0.block_id AS block_id_24,
  t0.data_sync_id AS data_sync_id_25
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.md5_hash AS md5_hash_3, t0.location AS location_4, t0.direction AS direction_5, t0.dimensions AS dimensions_6, t0.lighting AS lighting_7, t0.rent_per_month AS rent_per_month_8, t0.print_and_mount AS print_and_mount_9, t0.province AS province_10, t0.google_map_url AS google_map_url_11, t0.video_url AS video_url_12, t0.lat_lang AS lat_lang_13, t0.description AS description_14, t0.photo_url AS photo_url_15, t0.blocked_to AS blocked_to_16, t0.blocked_from AS blocked_from_17, t0.last_export_date AS last_export_date_18, t0.categories AS categories_19, t0.main_photo AS main_photo_20, t0.gallery AS gallery_21, t0.monthly_reach AS monthly_reach_22, t0.updated_at AS updated_at_23, t0.block_id AS block_id_24, t0.data_sync_id AS data_sync_id_25 FROM location t0 WHERE t0.id = '187';

SELECT
  DISTINCT l0_.id AS id_0
FROM
  location l0_
WHERE
  l0_.block_id IS NULL
LIMIT
  200

SELECT DISTINCT l0_.id AS id_0 FROM location l0_ WHERE l0_.block_id IS NULL LIMIT 200;

SELECT
  l0_.id AS id_0,
  l0_.created_at AS created_at_1,
  l0_.md5_hash AS md5_hash_2,
  l0_.location AS location_3,
  l0_.direction AS direction_4,
  l0_.dimensions AS dimensions_5,
  l0_.lighting AS lighting_6,
  l0_.rent_per_month AS rent_per_month_7,
  l0_.print_and_mount AS print_and_mount_8,
  l0_.province AS province_9,
  l0_.google_map_url AS google_map_url_10,
  l0_.video_url AS video_url_11,
  l0_.lat_lang AS lat_lang_12,
  l0_.description AS description_13,
  l0_.photo_url AS photo_url_14,
  l0_.blocked_to AS blocked_to_15,
  l0_.blocked_from AS blocked_from_16,
  l0_.last_export_date AS last_export_date_17,
  l0_.categories AS categories_18,
  l0_.main_photo AS main_photo_19,
  l0_.gallery AS gallery_20,
  l0_.monthly_reach AS monthly_reach_21,
  l0_.updated_at AS updated_at_22,
  l0_.block_id AS block_id_23,
  l0_.data_sync_id AS data_sync_id_24
FROM
  location l0_
WHERE
  l0_.block_id IS NULL
  AND l0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT l0_.id AS id_0, l0_.created_at AS created_at_1, l0_.md5_hash AS md5_hash_2, l0_.location AS location_3, l0_.direction AS direction_4, l0_.dimensions AS dimensions_5, l0_.lighting AS lighting_6, l0_.rent_per_month AS rent_per_month_7, l0_.print_and_mount AS print_and_mount_8, l0_.province AS province_9, l0_.google_map_url AS google_map_url_10, l0_.video_url AS video_url_11, l0_.lat_lang AS lat_lang_12, l0_.description AS description_13, l0_.photo_url AS photo_url_14, l0_.blocked_to AS blocked_to_15, l0_.blocked_from AS blocked_from_16, l0_.last_export_date AS last_export_date_17, l0_.categories AS categories_18, l0_.main_photo AS main_photo_19, l0_.gallery AS gallery_20, l0_.monthly_reach AS monthly_reach_21, l0_.updated_at AS updated_at_22, l0_.block_id AS block_id_23, l0_.data_sync_id AS data_sync_id_24 FROM location l0_ WHERE l0_.block_id IS NULL AND l0_.id IN (3, 4, 5, 6, 7, 8, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 39, 40, 41, 42, 43, 44, 47, 48, 49, 50, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 99, 100, 101, 102, 104, 114, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 154, 155, 156, 157, 158, 159, 160, 161, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215);

SELECT
  count(l0_.id) AS sclr_0
FROM
  location l0_
WHERE
  l0_.block_id IS NULL

SELECT count(l0_.id) AS sclr_0 FROM location l0_ WHERE l0_.block_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.object AS object_2,
  t0.current_chunk AS current_chunk_3,
  t0.chunk_quantity AS chunk_quantity_4,
  t0.created_at AS created_at_5,
  t0.finish_time AS finish_time_6,
  t0.busy AS busy_7,
  t0.status AS status_8,
  t0.method_name AS method_name_9,
  t0.import_id AS import_id_10,
  t0.data_sync_id AS data_sync_id_11
FROM
  data_sync_order t0
WHERE
  t0.object = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.object AS object_2, t0.current_chunk AS current_chunk_3, t0.chunk_quantity AS chunk_quantity_4, t0.created_at AS created_at_5, t0.finish_time AS finish_time_6, t0.busy AS busy_7, t0.status AS status_8, t0.method_name AS method_name_9, t0.import_id AS import_id_10, t0.data_sync_id AS data_sync_id_11 FROM data_sync_order t0 WHERE t0.object = 'App\\Entity\\LocationSyncBatch' AND t0.status = 'unsynchronized' LIMIT 1;