Query Metrics
26
Database Queries
16
Different statements
7.90 ms
Query time
0
Invalid entities
45
Managed entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.38 ms |
SELECT t0.name AS name_1, t0.available AS available_2, t0.sold AS sold_3, t0.public_name AS public_name_4, t0.color AS color_5, t0.listed AS listed_6, t0.auction AS auction_7, t0.search_terms AS search_terms_8, t0.public_short_name AS public_short_name_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.active AS active_13 FROM app_stock_status t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"HT"
]
|
2 | 0.54 ms |
SELECT t0.domain AS domain_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.company_address AS company_address_4, t0.company_phone_number AS company_phone_number_5, t0.company_contact_email AS company_contact_email_6, t0.logo_path AS logo_path_7, t0.logo_mobile_path AS logo_mobile_path_8, t0.main_color AS main_color_9, t0.secondary_color AS secondary_color_10, t0.banner_text AS banner_text_11, t0.banner_text_site_user AS banner_text_site_user_12, t0.no_auction_text AS no_auction_text_13, t0.auction_file_text AS auction_file_text_14, t0.auction_file_btn_text AS auction_file_btn_text_15, t0.created_since AS created_since_16, t0.vehicle_promo_path AS vehicle_promo_path_17, t0.auction_pdf_path AS auction_pdf_path_18, t0.test AS test_19, t0.home_title_h1 AS home_title_h1_20, t0.home_about_title AS home_about_title_21, t0.home_about_description AS home_about_description_22, t0.home_site_user_title AS home_site_user_title_23, t0.home_site_user_description AS home_site_user_description_24, t0.home_site_user_cta AS home_site_user_cta_25, t0.price_type AS price_type_26, t0.vehicle_no_picture_place_holder AS vehicle_no_picture_place_holder_27, t0.home_meta_title AS home_meta_title_28, t0.home_meta_description AS home_meta_description_29, t0.makers_meta_title AS makers_meta_title_30, t0.makers_meta_description AS makers_meta_description_31, t0.maker_meta_title AS maker_meta_title_32, t0.maker_meta_description AS maker_meta_description_33, t0.model_meta_title AS model_meta_title_34, t0.model_meta_description AS model_meta_description_35, t0.category_meta_title AS category_meta_title_36, t0.category_meta_description AS category_meta_description_37, t0.search_meta_title AS search_meta_title_38, t0.search_meta_description AS search_meta_description_39, t0.vehicle_meta_title AS vehicle_meta_title_40, t0.vehicle_meta_description AS vehicle_meta_description_41, t0.contact_meta_title AS contact_meta_title_42, t0.contact_meta_description AS contact_meta_description_43, t0.trade_car_meta_title AS trade_car_meta_title_44, t0.trade_car_meta_description AS trade_car_meta_description_45, t0.login_meta_title AS login_meta_title_46, t0.login_meta_description AS login_meta_description_47, t0.register_meta_title AS register_meta_title_48, t0.register_meta_description AS register_meta_description_49, t0.forgot_password_meta_title AS forgot_password_meta_title_50, t0.forgot_password_meta_description AS forgot_password_meta_description_51, t0.meta_title_pattern AS meta_title_pattern_52, t0.id AS id_53, t0.created_at AS created_at_54, t0.updated_at AS updated_at_55, t0.template_id AS template_id_56, t57.system_name AS system_name_58, t57.sms_name AS sms_name_59, t57.company_name AS company_name_60, t57.company_phone AS company_phone_61, t57.company_website AS company_website_62, t57.company_full_address AS company_full_address_63, t57.code_vehicle_alert AS code_vehicle_alert_64, t57.company_siret AS company_siret_65, t57.firstname_contact AS firstname_contact_66, t57.lastname_contact AS lastname_contact_67, t57.phone_contact AS phone_contact_68, t57.email_contact AS email_contact_69, t57.can_create_site AS can_create_site_70, t57.can_create_auction AS can_create_auction_71, t57.can_create_vehicle AS can_create_vehicle_72, t57.can_access_w2_p AS can_access_w2_p_73, t57.can_access_car_recevory AS can_access_car_recevory_74, t57.can_access_rdv AS can_access_rdv_75, t57.can_access_cg AS can_access_cg_76, t57.w2p_stores_number AS w2p_stores_number_77, t57.b2b AS b2b_78, t57.export_stock AS export_stock_79, t57.mailer AS mailer_80, t57.can_access_lead_manager AS can_access_lead_manager_81, t57.can_access_marketing AS can_access_marketing_82, t57.trade_car_margin AS trade_car_margin_83, t57.trade_car_km_max AS trade_car_km_max_84, t57.trade_car_primary_color_text AS trade_car_primary_color_text_85, t57.trade_car_secondary_color_text AS trade_car_secondary_color_text_86, t57.trade_car_primary_color_bg AS trade_car_primary_color_bg_87, t57.trade_car_secondary_color_bg AS trade_car_secondary_color_bg_88, t57.trade_car_text_hover_primary_color_bg AS trade_car_text_hover_primary_color_bg_89, t57.trade_car_text_hover_secondary_color_bg AS trade_car_text_hover_secondary_color_bg_90, t57.gtm_id AS gtm_id_91, t57.elastic_search_index_alias AS elastic_search_index_alias_92, t57.disclaimer_text AS disclaimer_text_93, t57.price_notice AS price_notice_94, t57.diffusion_api AS diffusion_api_95, t57.diffusion_starterre AS diffusion_starterre_96, t57.calendar_avant_access AS calendar_avant_access_97, t57.massive_selection AS massive_selection_98, t57.id AS id_99, t57.created_at AS created_at_100, t57.updated_at AS updated_at_101, t57.active AS active_102, t57.virtual_stock_id AS virtual_stock_id_103, t57.site_id AS site_id_104 FROM app_site t0 LEFT JOIN app_platform t57 ON t57.site_id = t0.id WHERE t0.domain = ? LIMIT 1
Parameters:
[
"www.intervo.fr"
]
|
3 | 0.48 ms |
SELECT t0.email_contact AS email_contact_1, t0.police_number AS police_number_2, t0.width AS width_3, t0.pictures AS pictures_4, t0.pictures_damage AS pictures_damage_5, t0.first_hand AS first_hand_6, t0.co2 AS co2_7, t0.delay_available AS delay_available_8, t0.finition AS finition_9, t0.reference_vehicule_owner AS reference_vehicule_owner_10, t0.reference_vehicule_owner_secondary AS reference_vehicule_owner_secondary_11, t0.gear_ratio AS gear_ratio_12, t0.taxable_horsepower AS taxable_horsepower_13, t0.year_production AS year_production_14, t0.name_contact AS name_contact_15, t0.place_number AS place_number_16, t0.guarantee_kilometers AS guarantee_kilometers_17, t0.kilometers AS kilometers_18, t0.last_technical_visit AS last_technical_visit_19, t0.cost_rehabilitation AS cost_rehabilitation_20, t0.version AS version_21, t0.expertise_url AS expertise_url_22, t0.id_vehicle AS id_vehicle_23, t0.length AS length_24, t0.phone_contact AS phone_contact_25, t0.merchant_sale_price_tax_incl AS merchant_sale_price_tax_incl_26, t0.merchant_sale_price_tax_excl AS merchant_sale_price_tax_excl_27, t0.merchant_sale_price_modified_at AS merchant_sale_price_modified_at_28, t0.merchant_sale_price_history AS merchant_sale_price_history_29, t0.public_sale_price_tax_incl AS public_sale_price_tax_incl_30, t0.public_sale_price_tax_excl AS public_sale_price_tax_excl_31, t0.public_sale_price_modified_at AS public_sale_price_modified_at_32, t0.public_sale_price_history AS public_sale_price_history_33, t0.value_new_option AS value_new_option_34, t0.purchase_price_tax_incl AS purchase_price_tax_incl_35, t0.purchase_price_tax_excl AS purchase_price_tax_excl_36, t0.supplier_name AS supplier_name_37, t0.public_comment AS public_comment_38, t0.private_comment AS private_comment_39, t0.qualification AS qualification_40, t0.origin AS origin_41, t0.country AS country_42, t0.purchase_zone AS purchase_zone_43, t0.entry_in_service_date AS entry_in_service_date_44, t0.erp_created_at AS erp_created_at_45, t0.height AS height_46, t0.true_power AS true_power_47, t0.color_accuracy AS color_accuracy_48, t0.inside_color AS inside_color_49, t0.doors_number AS doors_number_50, t0.weight AS weight_51, t0.guarantee_info AS guarantee_info_52, t0.pvo_code AS pvo_code_53, t0.wheel_base AS wheel_base_54, t0.url_rewrite AS url_rewrite_55, t0.deletedAt AS deletedAt_56, t0.expertise_path AS expertise_path_57, t0.vin AS vin_58, t0.license_number AS license_number_59, t0.is_recoverable_vat AS is_recoverable_vat_60, t0.serials_equipments AS serials_equipments_61, t0.optionals_equipments AS optionals_equipments_62, t0.type AS type_63, t0.gender AS gender_64, t0.engine_type AS engine_type_65, t0.mixte_consumption AS mixte_consumption_66, t0.drive_wheels AS drive_wheels_67, t0.minimum_engine_speed AS minimum_engine_speed_68, t0.maximum_engine_speed AS maximum_engine_speed_69, t0.motor_torque AS motor_torque_70, t0.maximum_torque AS maximum_torque_71, t0.tank_capacity AS tank_capacity_72, t0.car_trunk_volume AS car_trunk_volume_73, t0.maximum_speed AS maximum_speed_74, t0.zero_to_one_hundred AS zero_to_one_hundred_75, t0.total_weight AS total_weight_76, t0.maximal_power AS maximal_power_77, t0.seat_material AS seat_material_78, t0.id AS id_79, t0.created_at AS created_at_80, t0.updated_at AS updated_at_81, t0.active AS active_82, t0.stock_id AS stock_id_83, t0.category_id AS category_id_84, t0.segment_id AS segment_id_85, t0.stock_status_id AS stock_status_id_86, t0.maker_id AS maker_id_87, t0.model_id AS model_id_88, t0.energy_id AS energy_id_89, t0.gear_box_id AS gear_box_id_90, t0.color_id AS color_id_91, t0.location_id AS location_id_92 FROM app_vehicle t0 WHERE t0.url_rewrite = ? LIMIT 1
Parameters:
[
"2008-gt-1-2-puretech-130-cv-eat8-16625km-bc1lref"
]
|
4 | 0.16 ms |
SELECT t0.image_path AS image_path_1, t0.color AS color_2, t0.name AS name_3, t0.id_auto_vista AS id_auto_vista_4, t0.search_terms AS search_terms_5, t0.public_name AS public_name_6, t0.public_name_html AS public_name_html_7, t0.public_short_name AS public_short_name_8, t0.url_rewrite AS url_rewrite_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM app_maker t0 WHERE t0.id = ?
Parameters:
[
"41935368-208b-4021-9a7f-bb957c3df3d1"
]
|
5 | 0.42 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.color AS color_3, t0.ftp_host AS ftp_host_4, t0.ftp_port AS ftp_port_5, t0.ftp_path_flux AS ftp_path_flux_6, t0.ftp_path_photos AS ftp_path_photos_7, t0.username AS username_8, t0.password AS password_9, t0.url_flux AS url_flux_10, t0.price_tax_ecl AS price_tax_ecl_11, t0.need_preprocessing AS need_preprocessing_12, t0.internal AS internal_13, t0.automatic AS automatic_14, t0.ready_import AS ready_import_15, t0.processing AS processing_16, t0.error AS error_17, t0.import_error_at AS import_error_at_18, t0.import_error AS import_error_19, t0.imported_at AS imported_at_20, t0.system_name AS system_name_21, t0.phone_notifications AS phone_notifications_22, t0.kepler_api_version AS kepler_api_version_23, t0.kepler_api_key AS kepler_api_key_24, t0.kepler_api_domain AS kepler_api_domain_25, t0.slug_reference AS slug_reference_26, t0.supplier_mail_notifs AS supplier_mail_notifs_27, t0.supplier_mail_notif_sender AS supplier_mail_notif_sender_28, t0.kepler_fleet AS kepler_fleet_29, t0.kepler_params AS kepler_params_30, t0.extended_reference AS extended_reference_31, t0.in_import AS in_import_32, t0.in_preparation AS in_preparation_33, t0.force_fleet AS force_fleet_34, t0.arrivage_in_fleet AS arrivage_in_fleet_35, t0.merchant_price AS merchant_price_36, t0.public_price AS public_price_37, t0.virtual AS virtual_38, t0.send_bad_vehicle_notif AS send_bad_vehicle_notif_39, t0.id AS id_40, t0.created_at AS created_at_41, t0.updated_at AS updated_at_42, t0.active AS active_43, t44.path AS path_45, t44.final_path AS final_path_46, t44.processed AS processed_47, t44.processing AS processing_48, t44.header AS header_49, t44.position_report_url AS position_report_url_50, t44.position_cost AS position_cost_51, t44.position_vin AS position_vin_52, t44.position_price AS position_price_53, t44.position_version AS position_version_54, t44.position_vat AS position_vat_55, t44.position_mec AS position_mec_56, t44.position_source_picture AS position_source_picture_57, t44.position_equipments AS position_equipments_58, t44.position_immat AS position_immat_59, t44.position_km AS position_km_60, t44.date_processed AS date_processed_61, t44.percentage_completion AS percentage_completion_62, t44.email_notification AS email_notification_63, t44.expertise_type AS expertise_type_64, t44.id AS id_65, t44.created_at AS created_at_66, t44.updated_at AS updated_at_67, t44.stock_id AS stock_id_68 FROM app_stock t0 LEFT JOIN app_stock_file t44 ON t44.stock_id = t0.id INNER JOIN platform_stock ON t0.id = platform_stock.stock_id WHERE platform_stock.platform_id = ?
Parameters:
[
"8a135ac4-f8ab-47b5-be42-a62d4dc0c440"
]
|
6 | 1.12 ms |
SELECT a0_.price AS price_0, a0_.complete_start AS complete_start_1, a0_.complete_end AS complete_end_2, a0_.deletedAt AS deletedAt_3, a0_.auction_valid AS auction_valid_4, a0_.auction_valid_date AS auction_valid_date_5, a0_.id AS id_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.vehicle_id AS vehicle_id_9, a0_.site_id AS site_id_10 FROM app_auction a0_ WHERE a0_.complete_start <= ? AND a0_.complete_end >= ? ORDER BY a0_.complete_end ASC
Parameters:
[ "2025-06-29 04:05:34" "2025-06-29 04:05:34" ] |
7 | 0.19 ms |
SELECT a0_.media_desktop AS media_desktop_0, a0_.media_mobile AS media_mobile_1, a0_.title AS title_2, a0_.url AS url_3, a0_.location AS location_4, a0_.site_user_logon AS site_user_logon_5, a0_.date_start AS date_start_6, a0_.date_end AS date_end_7, a0_.id AS id_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.active AS active_11, CASE WHEN ((a0_.date_start IS NULL OR a0_.date_start <= ?) AND (a0_.date_end IS NULL OR a0_.date_end >= ?)) THEN 0 WHEN (a0_.date_start IS NULL AND a0_.date_end IS NULL) THEN 1 ELSE 2 END AS sclr_12, a0_.site_id AS site_id_13 FROM app_site_com_advertise a0_ WHERE a0_.location = ? AND a0_.site_user_logon = 0 AND a0_.active = 1 ORDER BY sclr_12 ASC LIMIT 1
Parameters:
[ "2025-06-29 04:05:34" "2025-06-29 04:05:34" "vehicle_col" ] |
8 | 0.12 ms |
SELECT t0.name AS name_1, t0.system_name AS system_name_2, t0.preview_image_path AS preview_image_path_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.active AS active_7 FROM app_template t0 WHERE t0.id = ?
Parameters:
[
"1fdf0ae4-592d-4a50-b1d6-fbf4e245a643"
]
|
9 | 0.22 ms |
SELECT t0.url AS url_1, t0.bg_color AS bg_color_2, t0.target_blank AS target_blank_3, t0.label AS label_4, t0.configured_page AS configured_page_5, t0.position AS position_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.maker_id AS maker_id_11, t0.page_id AS page_id_12, t0.footer_column_id AS footer_column_id_13 FROM app_main_menu_link t0 WHERE t0.site_id = ? AND t0.footer_column_id IS NULL ORDER BY t0.position ASC
Parameters:
[
"07942c4b-7a39-4fda-9255-390737765055"
]
|
10 | 0.27 ms |
SELECT t0.title AS title_1, t0.position AS position_2, t0.type AS type_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.active AS active_7, t0.site_id AS site_id_8 FROM app_footer_column t0 WHERE t0.site_id = ? AND t0.active = ? ORDER BY t0.position ASC
Parameters:
[ "07942c4b-7a39-4fda-9255-390737765055" 1 ] |
11 | 0.24 ms |
SELECT t0.url AS url_1, t0.bg_color AS bg_color_2, t0.target_blank AS target_blank_3, t0.label AS label_4, t0.configured_page AS configured_page_5, t0.position AS position_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.maker_id AS maker_id_11, t0.page_id AS page_id_12, t0.footer_column_id AS footer_column_id_13 FROM app_main_menu_link t0 WHERE t0.site_id = ? AND t0.footer_column_id = ? ORDER BY t0.position ASC
Parameters:
[ "07942c4b-7a39-4fda-9255-390737765055" "10b39700-0442-4b11-ae29-7f8059737495" ] |
12 | 0.62 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.site_id AS site_id_9 FROM app_page t0 WHERE t0.id = ?
Parameters:
[
"4a663fbe-a1b8-4e21-85e9-bec9e5086a0a"
]
|
13 | 0.27 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.site_id AS site_id_9 FROM app_page t0 WHERE t0.id = ?
Parameters:
[
"fa05f4a6-7e11-4261-a600-88aff21626bd"
]
|
14 | 0.14 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.site_id AS site_id_9 FROM app_page t0 WHERE t0.id = ?
Parameters:
[
"40b6c09c-abba-4724-a160-ae4a202ab806"
]
|
15 | 0.13 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.site_id AS site_id_9 FROM app_page t0 WHERE t0.id = ?
Parameters:
[
"670476ec-761f-46d5-981e-1638ed43dc7b"
]
|
16 | 0.10 ms |
SELECT t0.title AS title_1, t0.content AS content_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.url AS url_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.site_id AS site_id_9 FROM app_page t0 WHERE t0.id = ?
Parameters:
[
"a862dc52-fb77-47f2-8223-af30be5a2242"
]
|
17 | 0.14 ms |
SELECT t0.url AS url_1, t0.bg_color AS bg_color_2, t0.target_blank AS target_blank_3, t0.label AS label_4, t0.configured_page AS configured_page_5, t0.position AS position_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.maker_id AS maker_id_11, t0.page_id AS page_id_12, t0.footer_column_id AS footer_column_id_13 FROM app_main_menu_link t0 WHERE t0.site_id = ? AND t0.footer_column_id = ? ORDER BY t0.position ASC
Parameters:
[ "07942c4b-7a39-4fda-9255-390737765055" "aad98432-4684-4f93-90df-af94d48987ff" ] |
18 | 0.14 ms |
SELECT t0.image_path AS image_path_1, t0.color AS color_2, t0.name AS name_3, t0.id_auto_vista AS id_auto_vista_4, t0.search_terms AS search_terms_5, t0.public_name AS public_name_6, t0.public_name_html AS public_name_html_7, t0.public_short_name AS public_short_name_8, t0.url_rewrite AS url_rewrite_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM app_maker t0 WHERE t0.id = ?
Parameters:
[
"8a97713a-d064-4dea-8e37-771b5bafa297"
]
|
19 | 0.11 ms |
SELECT t0.image_path AS image_path_1, t0.color AS color_2, t0.name AS name_3, t0.id_auto_vista AS id_auto_vista_4, t0.search_terms AS search_terms_5, t0.public_name AS public_name_6, t0.public_name_html AS public_name_html_7, t0.public_short_name AS public_short_name_8, t0.url_rewrite AS url_rewrite_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM app_maker t0 WHERE t0.id = ?
Parameters:
[
"1dd7ee9a-0d6b-4305-ad44-7135b1426913"
]
|
20 | 0.14 ms |
SELECT t0.url AS url_1, t0.bg_color AS bg_color_2, t0.target_blank AS target_blank_3, t0.label AS label_4, t0.configured_page AS configured_page_5, t0.position AS position_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.maker_id AS maker_id_11, t0.page_id AS page_id_12, t0.footer_column_id AS footer_column_id_13 FROM app_main_menu_link t0 WHERE t0.site_id = ? AND t0.footer_column_id = ? ORDER BY t0.position ASC
Parameters:
[ "07942c4b-7a39-4fda-9255-390737765055" "e80c0f7b-7723-4730-9bac-6485eb6314d3" ] |
21 | 0.16 ms |
SELECT t0.url AS url_1, t0.bg_color AS bg_color_2, t0.target_blank AS target_blank_3, t0.label AS label_4, t0.configured_page AS configured_page_5, t0.position AS position_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.site_id AS site_id_10, t0.maker_id AS maker_id_11, t0.page_id AS page_id_12, t0.footer_column_id AS footer_column_id_13 FROM app_main_menu_link t0 WHERE t0.site_id = ? AND t0.footer_column_id = ? ORDER BY t0.position ASC
Parameters:
[ "07942c4b-7a39-4fda-9255-390737765055" "4fa228a0-63a0-40ce-8023-b63a537456e4" ] |
22 | 0.43 ms |
SELECT a0_.url AS url_0, a0_.url_token AS url_token_1, a0_.traffic_type AS traffic_type_2, a0_.ip AS ip_3, a0_.visitedAt AS visitedAt_4, a0_.visitorToken AS visitorToken_5, a0_.referrer AS referrer_6, a0_.route AS route_7, a0_.params AS params_8, a0_.user_agent AS user_agent_9, a0_.title AS title_10, a0_.event AS event_11, a0_.utm_source AS utm_source_12, a0_.utm_campaign AS utm_campaign_13, a0_.utm_medium AS utm_medium_14, a0_.utm_content AS utm_content_15, a0_.origin AS origin_16, a0_.id_vehicle AS id_vehicle_17, a0_.id_maker AS id_maker_18, a0_.id_model AS id_model_19, a0_.id_category AS id_category_20, a0_.id_preset AS id_preset_21, a0_.id_page AS id_page_22, a0_.id AS id_23, a0_.created_at AS created_at_24, a0_.updated_at AS updated_at_25, a0_.site_user_id AS site_user_id_26, a0_.site_id AS site_id_27 FROM app_core_msa_tracking_site_visit a0_ WHERE a0_.site_id = ? AND a0_.url_token = ? AND a0_.visitedAt > ? AND a0_.visitedAt < ? AND a0_.visitorToken = ? ORDER BY a0_.visitedAt DESC LIMIT 1
Parameters:
[ Ramsey\Uuid\Lazy\LazyUuidFromString {#118 : "07942c4b-7a39-4fda-9255-390737765055" } "71a7cc02b29a142d758cf16a8edeec2b" "2025-06-29 04:04:34" "2025-06-29 04:05:34" Ramsey\Uuid\Lazy\LazyUuidFromString {#5524 : "27162a0f-e827-4e7e-aa03-19c1931c4cfb" } ] |
23 | 0.36 ms |
SELECT t0.email_contact AS email_contact_1, t0.police_number AS police_number_2, t0.width AS width_3, t0.pictures AS pictures_4, t0.pictures_damage AS pictures_damage_5, t0.first_hand AS first_hand_6, t0.co2 AS co2_7, t0.delay_available AS delay_available_8, t0.finition AS finition_9, t0.reference_vehicule_owner AS reference_vehicule_owner_10, t0.reference_vehicule_owner_secondary AS reference_vehicule_owner_secondary_11, t0.gear_ratio AS gear_ratio_12, t0.taxable_horsepower AS taxable_horsepower_13, t0.year_production AS year_production_14, t0.name_contact AS name_contact_15, t0.place_number AS place_number_16, t0.guarantee_kilometers AS guarantee_kilometers_17, t0.kilometers AS kilometers_18, t0.last_technical_visit AS last_technical_visit_19, t0.cost_rehabilitation AS cost_rehabilitation_20, t0.version AS version_21, t0.expertise_url AS expertise_url_22, t0.id_vehicle AS id_vehicle_23, t0.length AS length_24, t0.phone_contact AS phone_contact_25, t0.merchant_sale_price_tax_incl AS merchant_sale_price_tax_incl_26, t0.merchant_sale_price_tax_excl AS merchant_sale_price_tax_excl_27, t0.merchant_sale_price_modified_at AS merchant_sale_price_modified_at_28, t0.merchant_sale_price_history AS merchant_sale_price_history_29, t0.public_sale_price_tax_incl AS public_sale_price_tax_incl_30, t0.public_sale_price_tax_excl AS public_sale_price_tax_excl_31, t0.public_sale_price_modified_at AS public_sale_price_modified_at_32, t0.public_sale_price_history AS public_sale_price_history_33, t0.value_new_option AS value_new_option_34, t0.purchase_price_tax_incl AS purchase_price_tax_incl_35, t0.purchase_price_tax_excl AS purchase_price_tax_excl_36, t0.supplier_name AS supplier_name_37, t0.public_comment AS public_comment_38, t0.private_comment AS private_comment_39, t0.qualification AS qualification_40, t0.origin AS origin_41, t0.country AS country_42, t0.purchase_zone AS purchase_zone_43, t0.entry_in_service_date AS entry_in_service_date_44, t0.erp_created_at AS erp_created_at_45, t0.height AS height_46, t0.true_power AS true_power_47, t0.color_accuracy AS color_accuracy_48, t0.inside_color AS inside_color_49, t0.doors_number AS doors_number_50, t0.weight AS weight_51, t0.guarantee_info AS guarantee_info_52, t0.pvo_code AS pvo_code_53, t0.wheel_base AS wheel_base_54, t0.url_rewrite AS url_rewrite_55, t0.deletedAt AS deletedAt_56, t0.expertise_path AS expertise_path_57, t0.vin AS vin_58, t0.license_number AS license_number_59, t0.is_recoverable_vat AS is_recoverable_vat_60, t0.serials_equipments AS serials_equipments_61, t0.optionals_equipments AS optionals_equipments_62, t0.type AS type_63, t0.gender AS gender_64, t0.engine_type AS engine_type_65, t0.mixte_consumption AS mixte_consumption_66, t0.drive_wheels AS drive_wheels_67, t0.minimum_engine_speed AS minimum_engine_speed_68, t0.maximum_engine_speed AS maximum_engine_speed_69, t0.motor_torque AS motor_torque_70, t0.maximum_torque AS maximum_torque_71, t0.tank_capacity AS tank_capacity_72, t0.car_trunk_volume AS car_trunk_volume_73, t0.maximum_speed AS maximum_speed_74, t0.zero_to_one_hundred AS zero_to_one_hundred_75, t0.total_weight AS total_weight_76, t0.maximal_power AS maximal_power_77, t0.seat_material AS seat_material_78, t0.id AS id_79, t0.created_at AS created_at_80, t0.updated_at AS updated_at_81, t0.active AS active_82, t0.stock_id AS stock_id_83, t0.category_id AS category_id_84, t0.segment_id AS segment_id_85, t0.stock_status_id AS stock_status_id_86, t0.maker_id AS maker_id_87, t0.model_id AS model_id_88, t0.energy_id AS energy_id_89, t0.gear_box_id AS gear_box_id_90, t0.color_id AS color_id_91, t0.location_id AS location_id_92 FROM app_vehicle t0 WHERE t0.url_rewrite = ? LIMIT 1
Parameters:
[
"2008-gt-1-2-puretech-130-cv-eat8-16625km-bc1lref"
]
|
24 | 0.13 ms |
"START TRANSACTION"
Parameters:
[] |
25 | 0.59 ms |
INSERT INTO app_core_msa_tracking_site_visit (url, url_token, traffic_type, ip, visitedAt, visitorToken, referrer, route, params, user_agent, title, event, utm_source, utm_campaign, utm_medium, utm_content, origin, id_vehicle, id_maker, id_model, id_category, id_preset, id_page, id, created_at, updated_at, site_user_id, site_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "http://www.intervo.fr/voitures/peugeot/2008/2008-gt-1-2-puretech-130-cv-eat8-16625km-bc1lref" "71a7cc02b29a142d758cf16a8edeec2b" "bot" "10.10.10.3" "2025-06-29 04:05:34" "27162a0f-e827-4e7e-aa03-19c1931c4cfb" null "app_front_site_vehicle_show" "a:4:{s:5:"_host";s:14:"www.intervo.fr";s:12:"makerRewrite";s:7:"peugeot";s:12:"modelRewrite";s:4:"2008";s:14:"vehicleRewrite";s:48:"2008-gt-1-2-puretech-130-cv-eat8-16625km-bc1lref";}" "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "InterVO - PEUGEOT 2008 GT 1.2 PURETECH 130 CV EAT8" "pageview" null null null null null "745e747a-8736-4420-9bcb-b909037bcecc" null null null null null "ed909a83-2cba-41d4-ab74-1cfd6a717ada" "2025-06-29 04:05:34" "2025-06-29 04:05:34" null "07942c4b-7a39-4fda-9255-390737765055" ] |
26 | 0.26 ms |
"COMMIT"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
Class | Amount of managed objects |
---|---|
App\Entity\MainMenuLink | 18 |
App\Entity\FooterColumn | 5 |
App\Entity\Page | 5 |
App\Entity\Core\Vehicle\Field\Maker | 3 |
App\Entity\Core\Stock\Stock | 2 |
App\Entity\Core\Vehicle\Field\StockStatus | 1 |
App\Entity\Site | 1 |
App\Entity\Template | 1 |
App\Entity\Platform | 1 |
App\Entity\Core\Vehicle\Vehicle | 1 |
App\Entity\Core\Vehicle\Field\Category | 1 |
App\Entity\Core\Vehicle\Field\Model | 1 |
App\Entity\Core\Vehicle\Field\Energy | 1 |
App\Entity\Core\Vehicle\Field\GearBox | 1 |
App\Entity\Core\Vehicle\Field\Color | 1 |
App\Entity\Core\Vehicle\Field\Location | 1 |
App\Entity\Core\Msa\Tracking\SiteVisit | 1 |