Query Metrics
3
Database Queries
2
Different statements
3.59 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.21 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 INNER JOIN room r2_ ON s0_.room_id = r2_.id WHERE s0_.type = ? AND s0_.room_id IS NOT NULL AND s0_.endDate > ? AND r2_.code = ? ORDER BY s0_.startDate ASC LIMIT 1
Parameters:
[ "Physique" "2026-02-04 11:17:38" "nantes" ] |
| 2 | 1.10 ms |
SELECT t0.id AS id_2, t0.type AS type_3, t0.title AS title_4, t0.startDate AS startDate_5, t0.endDate AS endDate_6, t0.recoveryAt AS recoveryAt_7, t0.description AS description_8, t0.status AS status_9, t0.bidIncrement AS bidIncrement_10, t0.vatRate AS vatRate_11, t0.dynamicClosing AS dynamicClosing_12, t0.extraTime AS extraTime_13, t0.salingType AS salingType_14, t0.publicationDate AS publicationDate_15, t0.expositionStartDate AS expositionStartDate_16, t0.expositionEndDate AS expositionEndDate_17, t0.dayExpositionTime AS dayExpositionTime_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.hours AS hours_21, t0.bannerUrl AS bannerUrl_22, t0.logoUrl AS logoUrl_23, t0.company AS company_24, t0.stock AS stock_25, t0.public AS public_26, t0.displayExplodedView AS displayExplodedView_27, t0.displayReconditioningFees AS displayReconditioningFees_28, t0.isLive AS isLive_29, t0.noVehicles AS noVehicles_30, t0.liveVisitors AS liveVisitors_31, t0.afterSaleDuration AS afterSaleDuration_32, t0.exclusive AS exclusive_33, t0.prepared AS prepared_34, t0.fixedFees AS fixedFees_35, t0.closedAt AS closedAt_36, t0.country AS country_37, t0.iridiumId AS iridiumId_38, t0.room_id AS room_id_39, t0.vehicle_opened_id AS vehicle_opened_id_40, t0.last_opened_vehicle_id AS last_opened_vehicle_id_41, t0.discr, t1.provider AS provider_42, t1.providerId AS providerId_43, t1.providerType AS providerType_44, t1.tracked AS tracked_45, t1.importStatus AS importStatus_46, t1.endOfSaleProcessed AS endOfSaleProcessed_47, t1.originalTitle AS originalTitle_48 FROM sale t0 LEFT JOIN external_sale t1 ON t0.id = t1.id WHERE t0.id = ? LIMIT 1
Parameters:
[
"nantes"
]
|
| 3 | 1.28 ms |
SELECT t0.id AS id_2, t0.type AS type_3, t0.title AS title_4, t0.startDate AS startDate_5, t0.endDate AS endDate_6, t0.recoveryAt AS recoveryAt_7, t0.description AS description_8, t0.status AS status_9, t0.bidIncrement AS bidIncrement_10, t0.vatRate AS vatRate_11, t0.dynamicClosing AS dynamicClosing_12, t0.extraTime AS extraTime_13, t0.salingType AS salingType_14, t0.publicationDate AS publicationDate_15, t0.expositionStartDate AS expositionStartDate_16, t0.expositionEndDate AS expositionEndDate_17, t0.dayExpositionTime AS dayExpositionTime_18, t0.createdAt AS createdAt_19, t0.updatedAt AS updatedAt_20, t0.hours AS hours_21, t0.bannerUrl AS bannerUrl_22, t0.logoUrl AS logoUrl_23, t0.company AS company_24, t0.stock AS stock_25, t0.public AS public_26, t0.displayExplodedView AS displayExplodedView_27, t0.displayReconditioningFees AS displayReconditioningFees_28, t0.isLive AS isLive_29, t0.noVehicles AS noVehicles_30, t0.liveVisitors AS liveVisitors_31, t0.afterSaleDuration AS afterSaleDuration_32, t0.exclusive AS exclusive_33, t0.prepared AS prepared_34, t0.fixedFees AS fixedFees_35, t0.closedAt AS closedAt_36, t0.country AS country_37, t0.iridiumId AS iridiumId_38, t0.room_id AS room_id_39, t0.vehicle_opened_id AS vehicle_opened_id_40, t0.last_opened_vehicle_id AS last_opened_vehicle_id_41, t0.discr, t1.provider AS provider_42, t1.providerId AS providerId_43, t1.providerType AS providerType_44, t1.tracked AS tracked_45, t1.importStatus AS importStatus_46, t1.endOfSaleProcessed AS endOfSaleProcessed_47, t1.originalTitle AS originalTitle_48 FROM sale t0 LEFT JOIN external_sale t1 ON t0.id = t1.id WHERE t0.id = ? LIMIT 1
Parameters:
[
-1
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Sale | No errors. |
| App\Entity\Room | No errors. |
| App\Entity\ExternalSale | No errors. |
| App\Entity\Vehicle | No errors. |