Query Metrics
13
Database Queries
4
Different statements
60.83 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 8.22 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"google.verif_tag.enabled"
]
|
2 | 3.68 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"bing.verif_tag.enabled"
]
|
3 | 8.70 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"cookiebot.id"
]
|
4 | 3.06 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"matomo.url"
]
|
5 | 8.36 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"kameleoon_ab_testing.enabled"
]
|
6 | 2.96 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"tracking.tag_manager"
]
|
7 | 6.40 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"yandex_metrica.enabled"
]
|
8 | 3.88 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.startDate AS startDate_3, s0_.endDate AS endDate_4, s0_.recoveryAt AS recoveryAt_5, s0_.description AS description_6, s0_.status AS status_7, s0_.bidIncrement AS bidIncrement_8, s0_.vatRate AS vatRate_9, s0_.dynamicClosing AS dynamicClosing_10, s0_.extraTime AS extraTime_11, s0_.salingType AS salingType_12, s0_.publicationDate AS publicationDate_13, s0_.expositionStartDate AS expositionStartDate_14, s0_.expositionEndDate AS expositionEndDate_15, s0_.dayExpositionTime AS dayExpositionTime_16, s0_.createdAt AS createdAt_17, s0_.updatedAt AS updatedAt_18, s0_.hours AS hours_19, s0_.bannerUrl AS bannerUrl_20, s0_.logoUrl AS logoUrl_21, s0_.company AS company_22, s0_.stock AS stock_23, s0_.public AS public_24, s0_.displayExplodedView AS displayExplodedView_25, s0_.displayReconditioningFees AS displayReconditioningFees_26, s0_.isLive AS isLive_27, s0_.noVehicles AS noVehicles_28, s0_.liveVisitors AS liveVisitors_29, s0_.afterSaleDuration AS afterSaleDuration_30, s0_.exclusive AS exclusive_31, s0_.prepared AS prepared_32, s0_.fixedFees AS fixedFees_33, s0_.closedAt AS closedAt_34, s0_.country AS country_35, s0_.iridiumId AS iridiumId_36, e1_.provider AS provider_37, e1_.providerId AS providerId_38, e1_.providerType AS providerType_39, e1_.tracked AS tracked_40, e1_.importStatus AS importStatus_41, e1_.endOfSaleProcessed AS endOfSaleProcessed_42, e1_.originalTitle AS originalTitle_43, s0_.discr AS discr_44, s0_.room_id AS room_id_45, s0_.vehicle_opened_id AS vehicle_opened_id_46, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id LEFT JOIN sale_buyersgroup s3_ ON s0_.id = s3_.sale_id LEFT JOIN buyers_group b2_ ON b2_.id = s3_.buyersgroup_id WHERE s0_.endDate > ? ORDER BY s0_.startDate ASC
Parameters:
[
"2025-01-10 18:39:09"
]
|
9 | 3.05 ms |
SELECT v0_.maker AS maker_0, v0_.makerSlug AS makerSlug_1, SUM(v0_.nbViews) AS sclr_2 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND s2_.sale_id = -1 AND v0_.maker <> '' GROUP BY v0_.maker ORDER BY sclr_2 DESC LIMIT 8
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-01-10 18:35:00" ] |
10 | 3.64 ms |
SELECT DISTINCT s0_.id AS id_0, s0_.type AS type_1, s0_.title AS title_2, s0_.startDate AS startDate_3, s0_.endDate AS endDate_4, s0_.recoveryAt AS recoveryAt_5, s0_.description AS description_6, s0_.status AS status_7, s0_.bidIncrement AS bidIncrement_8, s0_.vatRate AS vatRate_9, s0_.dynamicClosing AS dynamicClosing_10, s0_.extraTime AS extraTime_11, s0_.salingType AS salingType_12, s0_.publicationDate AS publicationDate_13, s0_.expositionStartDate AS expositionStartDate_14, s0_.expositionEndDate AS expositionEndDate_15, s0_.dayExpositionTime AS dayExpositionTime_16, s0_.createdAt AS createdAt_17, s0_.updatedAt AS updatedAt_18, s0_.hours AS hours_19, s0_.bannerUrl AS bannerUrl_20, s0_.logoUrl AS logoUrl_21, s0_.company AS company_22, s0_.stock AS stock_23, s0_.public AS public_24, s0_.displayExplodedView AS displayExplodedView_25, s0_.displayReconditioningFees AS displayReconditioningFees_26, s0_.isLive AS isLive_27, s0_.noVehicles AS noVehicles_28, s0_.liveVisitors AS liveVisitors_29, s0_.afterSaleDuration AS afterSaleDuration_30, s0_.exclusive AS exclusive_31, s0_.prepared AS prepared_32, s0_.fixedFees AS fixedFees_33, s0_.closedAt AS closedAt_34, s0_.country AS country_35, s0_.iridiumId AS iridiumId_36, e1_.provider AS provider_37, e1_.providerId AS providerId_38, e1_.providerType AS providerType_39, e1_.tracked AS tracked_40, e1_.importStatus AS importStatus_41, e1_.endOfSaleProcessed AS endOfSaleProcessed_42, e1_.originalTitle AS originalTitle_43, s0_.discr AS discr_44, s0_.room_id AS room_id_45, s0_.vehicle_opened_id AS vehicle_opened_id_46, s0_.last_opened_vehicle_id AS last_opened_vehicle_id_47 FROM sale s0_ LEFT JOIN external_sale e1_ ON s0_.id = e1_.id LEFT JOIN sale_buyersgroup s3_ ON s0_.id = s3_.sale_id LEFT JOIN buyers_group b2_ ON b2_.id = s3_.buyersgroup_id WHERE s0_.endDate > ? ORDER BY s0_.startDate ASC
Parameters:
[
"2025-01-10 18:39:09"
]
|
11 | 3.07 ms |
SELECT v0_.maker AS maker_0, v0_.modelGroup AS modelGroup_1, v0_.makerSlug AS makerSlug_2, v0_.modelGroupSlug AS modelGroupSlug_3, SUM(v0_.nbViews) AS sclr_4 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s2_ ON v0_.event_id = s2_.id INNER JOIN sale s3_ ON s2_.sale_id = s3_.id LEFT JOIN external_sale e4_ ON s3_.id = e4_.id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND s2_.sale_id = -1 AND v0_.modelGroup <> '' GROUP BY v0_.modelGroup ORDER BY sclr_4 DESC LIMIT 10
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-01-10 18:35:00" ] |
12 | 2.92 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"vpautopro.ajax.salesList.call.interval"
]
|
13 | 2.90 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.array_value AS array_value_3, t0.type AS type_4, t0.category AS category_5, t0.tooltip AS tooltip_6, t0.name AS name_7 FROM parameter t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"tawkto_chat.enabled"
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
tarif | doctrine.dbal.tarif_connection |
autovista | doctrine.dbal.autovista_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.