Query Metrics
23
Database Queries
10
Different statements
99.30 ms
Query time
0
Invalid entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
31.14 ms (31.35%) |
13 |
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:
[
"home.auctioneer.number_selection"
]
|
|
29.71 ms (29.91%) |
2 |
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 15:09:21"
]
|
|
14.71 ms (14.81%) |
1 |
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 sale_event s2_ ON s0_.id = s2_.sale_id WHERE s0_.type IN (?, ?) AND s0_.isLive = 1 AND s0_.endDate > ? AND s0_.status <> ? ORDER BY s0_.startDate ASC, s2_.startTime ASC LIMIT 1
Parameters:
[ "Physique" "Live" "2025-01-10 15:09:21" "Fermée" ] |
|
8.24 ms (8.30%) |
1 |
SELECT v0_.id AS id_0, v0_.vehicleId AS vehicleId_1, v0_.photos AS photos_2, v0_.lot AS lot_3, v0_.lotComplement AS lotComplement_4, v0_.isranked AS isranked_5, v0_.salingState AS salingState_6, v0_.class AS class_7, v0_.maker AS maker_8, v0_.makerSlug AS makerSlug_9, v0_.modelGroup AS modelGroup_10, v0_.modelGroupSlug AS modelGroupSlug_11, v0_.segment AS segment_12, v0_.segmentSlug AS segmentSlug_13, v0_.segmentSize AS segmentSize_14, v0_.segmentSizeSlug AS segmentSizeSlug_15, v0_.segmentBody AS segmentBody_16, v0_.model AS model_17, v0_.typeCode AS typeCode_18, v0_.millesime AS millesime_19, v0_.registrationDate AS registrationDate_20, v0_.kilometers AS kilometers_21, v0_.taxHorsepower AS taxHorsepower_22, v0_.bodyType AS bodyType_23, v0_.stateDetails AS stateDetails_24, v0_.guarantee AS guarantee_25, v0_.guaranteed AS guaranteed_26, v0_.stateRating AS stateRating_27, v0_.afnor AS afnor_28, v0_.etincelleId AS etincelleId_29, v0_.iridiumId AS iridiumId_30, v0_.vat AS vat_31, v0_.seatCount AS seatCount_32, v0_.observation AS observation_33, v0_.motFileUrl AS motFileUrl_34, v0_.maintenanceFileUrl AS maintenanceFileUrl_35, v0_.roadTestFileUrl AS roadTestFileUrl_36, v0_.bilanExpertFileUrl AS bilanExpertFileUrl_37, v0_.photo3dExteriorUrl AS photo3dExteriorUrl_38, v0_.photo3dExteriorExtraUrl AS photo3dExteriorExtraUrl_39, v0_.explodedViewFileUrl AS explodedViewFileUrl_40, v0_.dekraUrl AS dekraUrl_41, v0_.inspectionReportUrl AS inspectionReportUrl_42, v0_.argusPrice AS argusPrice_43, v0_.argusTransactionPrice AS argusTransactionPrice_44, v0_.argusAnnoncePrice AS argusAnnoncePrice_45, v0_.argusDatedPrice AS argusDatedPrice_46, v0_.argusKmPrice AS argusKmPrice_47, v0_.spotPrice AS spotPrice_48, v0_.reconditioningPrice AS reconditioningPrice_49, v0_.estimationPrice AS estimationPrice_50, v0_.estimationPriceMin AS estimationPriceMin_51, v0_.initialReservePrice AS initialReservePrice_52, v0_.initialReservePriceHF AS initialReservePriceHF_53, v0_.reservePrice AS reservePrice_54, v0_.reservePriceHF AS reservePriceHF_55, v0_.oldReservePrice AS oldReservePrice_56, v0_.oldReservePriceHF AS oldReservePriceHF_57, v0_.deltaReservePrice AS deltaReservePrice_58, v0_.deltaFees AS deltaFees_59, v0_.unusedPrice AS unusedPrice_60, v0_.startingPrice AS startingPrice_61, v0_.buyoutPrice AS buyoutPrice_62, v0_.unsoldPrice AS unsoldPrice_63, v0_.unsoldOnlinePrice AS unsoldOnlinePrice_64, v0_.lastHammerPrice AS lastHammerPrice_65, v0_.finalAmount AS finalAmount_66, v0_.unsoldCount AS unsoldCount_67, v0_.unsoldOnlineCount AS unsoldOnlineCount_68, v0_.broken AS broken_69, v0_.duplicateKeys AS duplicateKeys_70, v0_.co2 AS co2_71, v0_.euroEmissionStandard AS euroEmissionStandard_72, v0_.shortModel AS shortModel_73, v0_.version AS version_74, v0_.length AS length_75, v0_.width AS width_76, v0_.height AS height_77, v0_.tarification AS tarification_78, v0_.tarificationType AS tarificationType_79, v0_.zipCodeLocation AS zipCodeLocation_80, v0_.cityLocation AS cityLocation_81, v0_.lotOpen AS lotOpen_82, v0_.justOpened AS justOpened_83, v0_.nbViews AS nbViews_84, v0_.noShipping AS noShipping_85, v0_.salesperson AS salesperson_86, v0_.etincelleCreatedAt AS etincelleCreatedAt_87, v0_.etincelleSalingState AS etincelleSalingState_88, v0_.etincelleSalingStateComplement AS etincelleSalingStateComplement_89, v0_.urgent AS urgent_90, v0_.mandateDate AS mandateDate_91, v0_.soldDate AS soldDate_92, v0_.registrationPlate AS registrationPlate_93, v0_.adjustable AS adjustable_94, v0_.emptyWeight AS emptyWeight_95, v0_.liftingCapacity AS liftingCapacity_96, v0_.liftingHeight AS liftingHeight_97, v0_.engineActualHourCount AS engineActualHourCount_98, v0_.wheelBase AS wheelBase_99, v0_.cylinderCount AS cylinderCount_100, v0_.doorCount AS doorCount_101, v0_.gearCount AS gearCount_102, v0_.driveWheel AS driveWheel_103, v0_.loadWeight AS loadWeight_104, v0_.horsePower AS horsePower_105, v0_.gearbox AS gearbox_106, v0_.maintenanceBookState AS maintenanceBookState_107, v0_.maintenanceFileState AS maintenanceFileState_108, v0_.makerGuarantee AS makerGuarantee_109, v0_.makerGuaranteeExpiredAt AS makerGuaranteeExpiredAt_110, v0_.makerGuaranteeKilometers AS makerGuaranteeKilometers_111, v0_.premiumGuarantee AS premiumGuarantee_112, v0_.premiumGuaranteeDescription AS premiumGuaranteeDescription_113, v0_.segmentFirst AS segmentFirst_114, v0_.firstHand AS firstHand_115, v0_.argusOID AS argusOID_116, v0_.natCode AS natCode_117, v0_.damaged AS damaged_118, v0_.sellerObservation AS sellerObservation_119, v0_.trainingVehicle AS trainingVehicle_120, v0_.taxi AS taxi_121, v0_.mechanicallyDamaged AS mechanicallyDamaged_122, v0_.innerStateRating AS innerStateRating_123, v0_.expertiseRating AS expertiseRating_124, v0_.highlight AS highlight_125, v0_.catalog AS catalog_126, v0_.catalogHighlight AS catalogHighlight_127, v0_.star AS star_128, v0_.starElectro AS starElectro_129, v0_.sellerCallback AS sellerCallback_130, v0_.sentToSap AS sentToSap_131, v0_.critair AS critair_132, v0_.deliveryRequest AS deliveryRequest_133, v0_.identificationType AS identificationType_134, v0_.etincelleReservePrice AS etincelleReservePrice_135, v0_.sellerEstimationPrice AS sellerEstimationPrice_136, v0_.etincelleReservePriceHF AS etincelleReservePriceHF_137, v0_.sellerEstimationPriceHF AS sellerEstimationPriceHF_138, v0_.estimationPriceHF AS estimationPriceHF_139, v0_.cocFileUrl AS cocFileUrl_140, v0_.carpassFileUrl AS carpassFileUrl_141, v0_.firstCountryRegistration AS firstCountryRegistration_142, v0_.co2Standard AS co2Standard_143, v0_.vin AS vin_144, v0_.dataHubUUID AS dataHubUUID_145, v0_.sapFile AS sapFile_146, e1_.sourceStartingPrice AS sourceStartingPrice_147, e1_.datahubStartingPrice AS datahubStartingPrice_148, e1_.datahubSpotPrice AS datahubSpotPrice_149, e1_.datahubEstimationPrice AS datahubEstimationPrice_150, e1_.datahubCoefficient AS datahubCoefficient_151, e1_.priceVariationFromBidIncrement AS priceVariationFromBidIncrement_152, e1_.firstRegistrationYear AS firstRegistrationYear_153, e1_.cylinderCapacity AS cylinderCapacity_154, e1_.accessories AS accessories_155, e1_.DMRReports AS DMRReports_156, e1_.vatValue AS vatValue_157, e1_.formattedAddress AS formattedAddress_158, e1_.supplierCountry AS supplierCountry_159, e1_.fuelType AS fuelType_160, e1_.dataHubExportState AS dataHubExportState_161, e1_.gearType AS gearType_162, e1_.locationName AS locationName_163, CASE WHEN v0_.lot IS NULL THEN 1 ELSE 0 END AS sclr_164, v0_.discr AS discr_165, v0_.event_id AS event_id_166, v0_.winner_id AS winner_id_167, v0_.transmission_id AS transmission_id_168, v0_.category_id AS category_id_169, v0_.energy_id AS energy_id_170, v0_.seller_id AS seller_id_171, v0_.color_id AS color_id_172 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_.star = (?) AND ((s3_.type = ? OR (s3_.type = ? AND s3_.public = ?))) AND s3_.room_id IS NOT NULL AND s3_.endDate > ? AND v0_.salingState NOT IN (?, ?, ?) AND v0_.photos <> (?) ORDER BY sclr_164 ASC LIMIT 0
Parameters:
[ 1 "Physique" "Electronique" "al" "2025-01-10 15:09:21" "Exclus" "Supprimé" "Absence mise à prix" "N;" ] |
|
6.46 ms (6.51%) |
1 |
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 WHERE s0_.endDate > ? ORDER BY s0_.startDate ASC LIMIT 1
Parameters:
[
"2025-01-10 15:09:21"
]
|
|
5.49 ms (5.53%) |
1 |
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 sale_event s2_ ON s0_.id = s2_.sale_id WHERE s0_.type IN (?, ?) AND s0_.isLive = 1 AND s0_.startDate LIKE ? ORDER BY s0_.endDate DESC
Parameters:
[ "Physique" "Live" "2025-01-10%" ] |
|
1.11 ms (1.12%) |
1 |
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 15:05:00" ] |
|
0.86 ms (0.87%) |
1 |
SELECT b0_.id AS id_0, b0_.alt AS alt_1, b0_.image AS image_2, b0_.imageMobile AS imageMobile_3, b0_.link AS link_4, b0_.type AS type_5, b0_.localeId AS localeId_6, b0_.priority AS priority_7, b0_.startDate AS startDate_8, b0_.endDate AS endDate_9, CASE WHEN b0_.priority IS NULL THEN 1 ELSE 0 END AS sclr_10 FROM banner b0_ WHERE b0_.type = ? AND b0_.startDate <= ? AND b0_.endDate > ? AND b0_.localeId = ? ORDER BY sclr_10 ASC, b0_.priority ASC, b0_.startDate ASC
Parameters:
[ "B2C" "2025-01-10 15:09:21" "2025-01-10 15:09:21" "fr" ] |
|
0.83 ms (0.83%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.link AS link_4, t0.type AS type_5 FROM news t0 WHERE t0.type = ?
Parameters:
[
"B2C"
]
|
|
0.75 ms (0.76%) |
1 |
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 15:05:00" ] |
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.