Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 43
• Events
• Routing
• Cache
• Translation 6
• Security
• Twig
• HTTP Client
• Doctrine 4
• Debug
• Messages
• Emails
• Notifications
• Serializer
• EasyAdmin
• Configuration

Query Metrics

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.id = ?

[
  15
]

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.id = ?

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.id = 15;

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 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  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
  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 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

[
  "App\Entity\LocationSyncBatch"
  "unsynchronized"
]

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;