Query Metrics
16
Database Queries
10
Different statements
83.47 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 61.73 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT 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, COALESCE(v0_.kilometers, 9999998) AS sclr_164, CASE WHEN v0_.photos <> 'N;' AND v0_.photos LIKE '%public%' THEN 100 ELSE 0 END AS sclr_165, v0_.discr AS discr_166 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 LEFT JOIN vehicle_category v5_ ON v0_.category_id = v5_.id LEFT JOIN vehicle_option v7_ ON v0_.id = v7_.vehicle_id LEFT JOIN option_item o6_ ON o6_.id = v7_.option_id LEFT JOIN vehicle_energy v8_ ON v0_.energy_id = v8_.id INNER JOIN room r9_ ON s3_.room_id = r9_.id INNER JOIN auction a10_ ON v0_.id = a10_.vehicle_id INNER JOIN sale_buyersgroup s12_ ON s3_.id = s12_.sale_id INNER JOIN buyers_group b11_ ON b11_.id = s12_.buyersgroup_id WHERE v0_.salingState NOT IN (?, ?, ?) AND s3_.endDate > ? AND s3_.id = ? AND b11_.name = ? ORDER BY v0_.isranked DESC, v0_.lot ASC, sclr_165 DESC, v0_.broken ASC, v0_.millesime DESC, sclr_164 ASC) dctrn_result) dctrn_table
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" -1 "Tous B2C" ] |
| 2 | 5.85 ms |
SELECT DISTINCT COUNT(v0_.id) AS sclr_0 FROM sale s1_ LEFT JOIN external_sale e2_ ON s1_.id = e2_.id LEFT JOIN sale_buyersgroup s4_ ON s1_.id = s4_.sale_id LEFT JOIN buyers_group b3_ ON b3_.id = s4_.buyersgroup_id INNER JOIN sale_event s5_ ON s1_.id = s5_.sale_id INNER JOIN vehicle v0_ ON s5_.id = v0_.event_id LEFT JOIN external_vehicle e6_ ON v0_.id = e6_.id WHERE s1_.endDate > ? AND ((s1_.type = ? OR (s1_.type = ? AND s1_.public = ?))) AND s1_.room_id IS NOT NULL AND v0_.salingState NOT IN (?, ?, ?) AND b3_.name = ? ORDER BY s1_.startDate ASC, s5_.startTime ASC
Parameters:
[ "2025-07-02 06:12:56" "Physique" "Electronique" "al" "Exclus" "Supprimé" "Absence mise à prix" "Tous B2C" ] |
| 3 | 2.29 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 INNER JOIN sale_event s4_ ON s0_.id = s4_.sale_id WHERE s0_.endDate > ? AND ((s0_.type = ? OR (s0_.type = ? AND s0_.public = ?))) AND s0_.room_id IS NOT NULL ORDER BY s0_.startDate ASC, s4_.startTime ASC
Parameters:
[ "2025-07-02 06:12:56" "Physique" "Electronique" "al" ] |
| 4 | 0.93 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"
]
|
| 5 | 0.84 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"
]
|
| 6 | 0.61 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"
]
|
| 7 | 0.49 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"
]
|
| 8 | 0.99 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"
]
|
| 9 | 0.69 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"
]
|
| 10 | 0.86 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"
]
|
| 11 | 3.99 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, isranked_5, lot_3, sclr_165, broken_69, millesime_19, sclr_164 FROM (SELECT DISTINCT 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, COALESCE(v0_.kilometers, 9999998) AS sclr_164, CASE WHEN v0_.photos <> 'N;' AND v0_.photos LIKE '%public%' THEN 100 ELSE 0 END AS sclr_165, s2_.id AS id_166, s2_.type AS type_167, s2_.title AS title_168, s2_.startDate AS startDate_169, s2_.endDate AS endDate_170, s2_.recoveryAt AS recoveryAt_171, s2_.description AS description_172, s2_.status AS status_173, s2_.bidIncrement AS bidIncrement_174, s2_.vatRate AS vatRate_175, s2_.dynamicClosing AS dynamicClosing_176, s2_.extraTime AS extraTime_177, s2_.salingType AS salingType_178, s2_.publicationDate AS publicationDate_179, s2_.expositionStartDate AS expositionStartDate_180, s2_.expositionEndDate AS expositionEndDate_181, s2_.dayExpositionTime AS dayExpositionTime_182, s2_.createdAt AS createdAt_183, s2_.updatedAt AS updatedAt_184, s2_.hours AS hours_185, s2_.bannerUrl AS bannerUrl_186, s2_.logoUrl AS logoUrl_187, s2_.company AS company_188, s2_.stock AS stock_189, s2_.public AS public_190, s2_.displayExplodedView AS displayExplodedView_191, s2_.displayReconditioningFees AS displayReconditioningFees_192, s2_.isLive AS isLive_193, s2_.noVehicles AS noVehicles_194, s2_.liveVisitors AS liveVisitors_195, s2_.afterSaleDuration AS afterSaleDuration_196, s2_.exclusive AS exclusive_197, s2_.prepared AS prepared_198, s2_.fixedFees AS fixedFees_199, s2_.closedAt AS closedAt_200, s2_.country AS country_201, s2_.iridiumId AS iridiumId_202, e3_.provider AS provider_203, e3_.providerId AS providerId_204, e3_.providerType AS providerType_205, e3_.tracked AS tracked_206, e3_.importStatus AS importStatus_207, e3_.endOfSaleProcessed AS endOfSaleProcessed_208, e3_.originalTitle AS originalTitle_209, b4_.id AS id_210, b4_.name AS name_211, b4_.salesforceId AS salesforceId_212, v0_.discr AS discr_213, s2_.discr AS discr_214 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id INNER JOIN sale_event s5_ ON v0_.event_id = s5_.id INNER JOIN sale s2_ ON s5_.sale_id = s2_.id LEFT JOIN external_sale e3_ ON s2_.id = e3_.id LEFT JOIN vehicle_category v6_ ON v0_.category_id = v6_.id LEFT JOIN vehicle_option v8_ ON v0_.id = v8_.vehicle_id LEFT JOIN option_item o7_ ON o7_.id = v8_.option_id LEFT JOIN vehicle_energy v9_ ON v0_.energy_id = v9_.id INNER JOIN room r10_ ON s2_.room_id = r10_.id INNER JOIN auction a11_ ON v0_.id = a11_.vehicle_id INNER JOIN sale_buyersgroup s12_ ON s2_.id = s12_.sale_id INNER JOIN buyers_group b4_ ON b4_.id = s12_.buyersgroup_id WHERE v0_.salingState NOT IN (?, ?, ?) AND s2_.endDate > ? AND s2_.id = ? AND b4_.name = ?) dctrn_result_inner ORDER BY isranked_5 DESC, lot_3 ASC, sclr_165 DESC, broken_69 ASC, millesime_19 DESC, sclr_164 ASC) dctrn_result LIMIT 96
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:10:00" -1 "Tous B2C" ] |
| 12 | 0.66 ms |
SELECT t0.id AS id_1, t0.name_canonical AS name_canonical_2, t0.name AS name_3, t0.rank AS rank_4, t0.rank_results AS rank_results_5 FROM vehicle_category t0
Parameters:
[] |
| 13 | 0.80 ms |
SELECT DISTINCT s0_.title AS title_0, s0_.id AS id_1 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 > ? AND s0_.type = ? AND s0_.room_id IS NOT NULL ORDER BY s0_.startDate ASC
Parameters:
[ "2025-07-02 06:12:56" "Physique" ] |
| 14 | 0.91 ms |
SELECT DISTINCT v0_.name_canonical AS name_canonical_0, v0_.name AS name_1 FROM vehicle v1_ LEFT JOIN external_vehicle e2_ ON v1_.id = e2_.id LEFT JOIN vehicle_category v0_ ON v1_.category_id = v0_.id LEFT JOIN sale_event s3_ ON v1_.event_id = s3_.id LEFT JOIN vehicle_energy v4_ ON v1_.energy_id = v4_.id LEFT JOIN sale s5_ ON s3_.sale_id = s5_.id LEFT JOIN external_sale e6_ ON s5_.id = e6_.id LEFT JOIN vehicle_option v8_ ON v1_.id = v8_.vehicle_id LEFT JOIN option_item o7_ ON o7_.id = v8_.option_id WHERE v1_.salingState NOT IN (?, ?, ?) AND v0_.name_canonical IS NOT NULL AND s5_.endDate > ? ORDER BY v0_.rank ASC
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:12:56" ] |
| 15 | 1.03 ms |
SELECT DISTINCT v0_.id AS id_0, v0_.name AS name_1 FROM vehicule_transmission v0_ WHERE v0_.name <> '' ORDER BY v0_.name ASC
Parameters:
[] |
| 16 | 0.79 ms |
SELECT DISTINCT v0_.critair AS critair_0, v0_.critair AS critair_1 FROM vehicle v0_ LEFT JOIN external_vehicle e1_ ON v0_.id = e1_.id LEFT JOIN vehicle_category v2_ ON v0_.category_id = v2_.id LEFT JOIN sale_event s3_ ON v0_.event_id = s3_.id LEFT JOIN vehicle_energy v4_ ON v0_.energy_id = v4_.id LEFT JOIN sale s5_ ON s3_.sale_id = s5_.id LEFT JOIN external_sale e6_ ON s5_.id = e6_.id LEFT JOIN vehicle_option v8_ ON v0_.id = v8_.vehicle_id LEFT JOIN option_item o7_ ON o7_.id = v8_.option_id WHERE v0_.salingState NOT IN (?, ?, ?) AND v0_.critair IS NOT NULL AND s5_.endDate > ? ORDER BY v0_.critair ASC
Parameters:
[ "Exclus" "Supprimé" "Absence mise à prix" "2025-07-02 06:12:56" ] |
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.