GET https://preprod.api.agenceauto.com/de/api/agency/ferney-voltaire

Response
200 OK
IP
149.202.122.83
Profiled on
Token
bdc596

Query Metrics

45 Database Queries
25 Different statements
116.44 ms Query time
3 Invalid entities
171 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
104.50 ms
(89.75%) 		1 
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.postal_code AS postal_code_2, c0_.latitude AS latitude_3, c0_.longitude AS longitude_4, c0_.insee_code AS insee_code_5, (6378 * ACOS(COS(RADIANS(c0_.latitude)) * COS(RADIANS(?)) * COS(RADIANS(?) - RADIANS(c0_.longitude)) + SIN(RADIANS(c0_.latitude)) * SIN(RADIANS(?)))) AS sclr_6, c0_.department_id AS department_id_7 FROM city c0_ ORDER BY sclr_6 ASC LIMIT 3
Parameters: 
[
  46.2586
  6.1106
  46.2586
]
View formatted query    View runnable query    Explain query    View query backtrace
1.19 ms
(1.02%) 		1 
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.slug AS slug_2, m1_.id AS id_3, m1_.name AS name_4, v2_.id AS id_5, v2_.finish AS finish_6, v2_.mileage AS mileage_7, v2_.in_service_date AS in_service_date_8, v2_.power AS power_9, v2_.power_din AS power_din_10, v2_.nb_door AS nb_door_11, v2_.nb_seat AS nb_seat_12, v2_.co2 AS co2_13, v2_.eloa_ref AS eloa_ref_14, v2_.eloa_statut AS eloa_statut_15, v2_.eloa_date_migration AS eloa_date_migration_16, v2_.active AS active_17, v2_.archive AS archive_18, v2_.archive_custom_reason AS archive_custom_reason_19, v2_.archived_at AS archived_at_20, v2_.brand_warranty_end_date AS brand_warranty_end_date_21, v2_.cantonal_annotation AS cantonal_annotation_22, v2_.chassis_number AS chassis_number_23, v2_.commission AS commission_24, v2_.created AS created_25, v2_.damaged AS damaged_26, v2_.damaged_description AS damaged_description_27, v2_.date_certificate_number_plate AS date_certificate_number_plate_28, v2_.description AS description_29, v2_.dual_key AS dual_key_30, v2_.engine_size AS engine_size_31, v2_.exclusive_sale AS exclusive_sale_32, v2_.financing_default_price AS financing_default_price_33, v2_.finish_leocare AS finish_leocare_34, v2_.formula_number_number_plate AS formula_number_number_plate_35, v2_.good_deal AS good_deal_36, v2_.horse_power AS horse_power_37, v2_.id_leocare AS id_leocare_38, v2_.interior AS interior_39, v2_.is_first_hand AS is_first_hand_40, v2_.is_leasing AS is_leasing_41, v2_.is_vat_recoverable AS is_vat_recoverable_42, v2_.is_yescar_repossession AS is_yescar_repossession_43, v2_.kw_power AS kw_power_44, v2_.last_revision_date AS last_revision_date_45, v2_.last_revision_description AS last_revision_description_46, v2_.last_revision_mileage AS last_revision_mileage_47, v2_.mileage_timing_belt AS mileage_timing_belt_48, v2_.min_price AS min_price_49, v2_.multicasted_elsewhere AS multicasted_elsewhere_50, v2_.multicasted_elsewhere_description AS multicasted_elsewhere_description_51, v2_.number_plate AS number_plate_52, v2_.original_price AS original_price_53, v2_.prestige AS prestige_54, v2_.price AS price_55, v2_.private_comment AS private_comment_56, v2_.reception_by_type AS reception_by_type_57, v2_.registration_number AS registration_number_58, v2_.seller_price AS seller_price_59, v2_.service_manual AS service_manual_60, v2_.size_rim AS size_rim_61, v2_.slug AS slug_62, v2_.technical_check_date AS technical_check_date_63, v2_.technical_check_description AS technical_check_description_64, v2_.timing_belt_description AS timing_belt_description_65, v2_.tire_back_left_description AS tire_back_left_description_66, v2_.tire_back_right_description AS tire_back_right_description_67, v2_.tire_front_left_description AS tire_front_left_description_68, v2_.tire_front_right_description AS tire_front_right_description_69, v2_.type_variant_version AS type_variant_version_70, v2_.under_sale_agreement AS under_sale_agreement_71, v2_.updated AS updated_72, v2_.use_as_security AS use_as_security_73, v2_.user_manual AS user_manual_74, v2_.warranty_duration AS warranty_duration_75, v2_.warranty_price AS warranty_price_76, v2_.workflow AS workflow_77, v2_.zip_archive AS zip_archive_78, v2_.has_lead_eloa AS has_lead_eloa_79, v2_.vehicle_migrated AS vehicle_migrated_80, v2_.eloa_updated_at AS eloa_updated_at_81, v2_.created_at AS created_at_82, v2_.updated_at AS updated_at_83, a3_.id AS id_84, a3_.name AS name_85, a3_.email AS email_86, a3_.multi_caster_id AS multi_caster_id_87, a3_.telephone AS telephone_88, a3_.siret AS siret_89, a3_.is_active AS is_active_90, a3_.eloa_ref AS eloa_ref_91, a3_.eloa_last_check AS eloa_last_check_92, a3_.eloa_statut AS eloa_statut_93, a3_.libelle AS libelle_94, a3_.reference_entite AS reference_entite_95, a3_.raison_sociale AS raison_sociale_96, a3_.ref_type_reseau AS ref_type_reseau_97, a3_.orias AS orias_98, a3_.description AS description_99, a3_.has_grey_card_service AS has_grey_card_service_100, a3_.slug AS slug_101, a3_.has_loyalty_program AS has_loyalty_program_102, a3_.has_up_my_shop AS has_up_my_shop_103, a3_.latitude AS latitude_104, a3_.longitude AS longitude_105, a3_.royalty_network_date AS royalty_network_date_106, a3_.royalty_remainder AS royalty_remainder_107, a3_.fiscal_code_it AS fiscal_code_it_108, a3_.leocare_id AS leocare_id_109, a3_.autoscout24_api_id AS autoscout24_api_id_110, a3_.up_my_shop_url AS up_my_shop_url_111, a3_.lacentrale_id AS lacentrale_id_112, a3_.has_annoncesautomobile AS has_annoncesautomobile_113, a3_.definitively_inactive AS definitively_inactive_114, a3_.first_contract_date AS first_contract_date_115, a3_.opening_date AS opening_date_116, a3_.vosfactures_id AS vosfactures_id_117, a3_.vosfactures_client_id AS vosfactures_client_id_118, a3_.grey_card_website AS grey_card_website_119, a3_.has_cps AS has_cps_120, a3_.contract_date AS contract_date_121, a3_.autoscout24_id AS autoscout24_id_122, a3_.paruvendu_id AS paruvendu_id_123, a3_.ouestfrance_id AS ouestfrance_id_124, a3_.atoutcoin_id AS atoutcoin_id_125, a3_.royalty_variable_date AS royalty_variable_date_126, a3_.royalty_communication_date AS royalty_communication_date_127, a3_.agency_migrated AS agency_migrated_128, a3_.facturation_id AS facturation_id_129, a3_.invoice_number AS invoice_number_130, a3_.address_number AS address_number_131, a3_.address_extension AS address_extension_132, a3_.address_street AS address_street_133, a3_.address AS address_134, a3_.created_at AS created_at_135, a3_.updated_at AS updated_at_136, m1_.make_id AS make_id_137, v2_.agency_id AS agency_id_138, v2_.transmission_id AS transmission_id_139, v2_.vehicle_type_id AS vehicle_type_id_140, v2_.critair_id AS critair_id_141, v2_.fuel_id AS fuel_id_142, v2_.model_id AS model_id_143, v2_.document_id AS document_id_144, v2_.user_id AS user_id_145, v2_.ambassador_id AS ambassador_id_146, v2_.archive_type_id AS archive_type_id_147, v2_.bodywork_id AS bodywork_id_148, v2_.buyer_id AS buyer_id_149, v2_.color_id AS color_id_150, v2_.euro_norm_id AS euro_norm_id_151, v2_.origin_id AS origin_id_152, v2_.workmate_registered_id AS workmate_registered_id_153, v2_.workmate_sold_id AS workmate_sold_id_154, v2_.vehicle_eloa_id AS vehicle_eloa_id_155, a3_.city_id AS city_id_156, a3_.company_id AS company_id_157, a3_.royalty_network_id AS royalty_network_id_158, a3_.royalty_communication_id AS royalty_communication_id_159, a3_.royalty_variable_id AS royalty_variable_id_160, a3_.close_reason_id AS close_reason_id_161 FROM make m0_ INNER JOIN model m1_ ON m0_.id = m1_.make_id INNER JOIN vehicle v2_ ON m1_.id = v2_.model_id INNER JOIN agency a3_ ON v2_.agency_id = a3_.id WHERE v2_.active IN (?) AND a3_.id IN (?) ORDER BY m0_.name ASC
Parameters: 
[
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.17 ms
(1.00%) 		5 
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_service IN (?) AND s0_.active IN (?) AND a2_.id IN (?) LIMIT 1
Parameters: 
[
  1
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(0.92%) 		5 
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_agency_presentation IN (?) AND s0_.active IN (?) AND a2_.id IN (?) LIMIT 1
Parameters: 
[
  1
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.07 ms
(0.92%) 		5 
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_quality_product_buyer IN (?) AND s0_.active IN (?) AND a2_.id IN (?) LIMIT 1
Parameters: 
[
  1
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.06 ms
(0.91%) 		5 
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_workmate IN (?) AND s0_.active IN (?) AND a2_.id IN (?) LIMIT 1
Parameters: 
[
  1
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.04 ms
(0.89%) 		5 
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM survey_satisfaction s0_ INNER JOIN vehicle v1_ ON s0_.vehicle_id = v1_.id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE s0_.note_price_buyer IN (?) AND s0_.active IN (?) AND a2_.id IN (?) LIMIT 1
Parameters: 
[
  1
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
1.02 ms
(0.88%) 		1 
SELECT b0_.id AS id_0, t1_.content AS name_1, b0_.ubiflow_id AS ubiflow_id_2, b0_.slug AS slug_3, b0_.lacentrale_id AS lacentrale_id_4, v2_.id AS id_5, v2_.finish AS finish_6, v2_.mileage AS mileage_7, v2_.in_service_date AS in_service_date_8, v2_.power AS power_9, v2_.power_din AS power_din_10, v2_.nb_door AS nb_door_11, v2_.nb_seat AS nb_seat_12, v2_.co2 AS co2_13, v2_.eloa_ref AS eloa_ref_14, v2_.eloa_statut AS eloa_statut_15, v2_.eloa_date_migration AS eloa_date_migration_16, v2_.active AS active_17, v2_.archive AS archive_18, v2_.archive_custom_reason AS archive_custom_reason_19, v2_.archived_at AS archived_at_20, v2_.brand_warranty_end_date AS brand_warranty_end_date_21, v2_.cantonal_annotation AS cantonal_annotation_22, v2_.chassis_number AS chassis_number_23, v2_.commission AS commission_24, v2_.created AS created_25, v2_.damaged AS damaged_26, v2_.damaged_description AS damaged_description_27, v2_.date_certificate_number_plate AS date_certificate_number_plate_28, v2_.description AS description_29, v2_.dual_key AS dual_key_30, v2_.engine_size AS engine_size_31, v2_.exclusive_sale AS exclusive_sale_32, v2_.financing_default_price AS financing_default_price_33, v2_.finish_leocare AS finish_leocare_34, v2_.formula_number_number_plate AS formula_number_number_plate_35, v2_.good_deal AS good_deal_36, v2_.horse_power AS horse_power_37, v2_.id_leocare AS id_leocare_38, v2_.interior AS interior_39, v2_.is_first_hand AS is_first_hand_40, v2_.is_leasing AS is_leasing_41, v2_.is_vat_recoverable AS is_vat_recoverable_42, v2_.is_yescar_repossession AS is_yescar_repossession_43, v2_.kw_power AS kw_power_44, v2_.last_revision_date AS last_revision_date_45, v2_.last_revision_description AS last_revision_description_46, v2_.last_revision_mileage AS last_revision_mileage_47, v2_.mileage_timing_belt AS mileage_timing_belt_48, v2_.min_price AS min_price_49, v2_.multicasted_elsewhere AS multicasted_elsewhere_50, v2_.multicasted_elsewhere_description AS multicasted_elsewhere_description_51, v2_.number_plate AS number_plate_52, v2_.original_price AS original_price_53, v2_.prestige AS prestige_54, v2_.price AS price_55, v2_.private_comment AS private_comment_56, v2_.reception_by_type AS reception_by_type_57, v2_.registration_number AS registration_number_58, v2_.seller_price AS seller_price_59, v2_.service_manual AS service_manual_60, v2_.size_rim AS size_rim_61, v2_.slug AS slug_62, v2_.technical_check_date AS technical_check_date_63, v2_.technical_check_description AS technical_check_description_64, v2_.timing_belt_description AS timing_belt_description_65, v2_.tire_back_left_description AS tire_back_left_description_66, v2_.tire_back_right_description AS tire_back_right_description_67, v2_.tire_front_left_description AS tire_front_left_description_68, v2_.tire_front_right_description AS tire_front_right_description_69, v2_.type_variant_version AS type_variant_version_70, v2_.under_sale_agreement AS under_sale_agreement_71, v2_.updated AS updated_72, v2_.use_as_security AS use_as_security_73, v2_.user_manual AS user_manual_74, v2_.warranty_duration AS warranty_duration_75, v2_.warranty_price AS warranty_price_76, v2_.workflow AS workflow_77, v2_.zip_archive AS zip_archive_78, v2_.has_lead_eloa AS has_lead_eloa_79, v2_.vehicle_migrated AS vehicle_migrated_80, v2_.eloa_updated_at AS eloa_updated_at_81, v2_.created_at AS created_at_82, v2_.updated_at AS updated_at_83, a3_.id AS id_84, a3_.name AS name_85, a3_.email AS email_86, a3_.multi_caster_id AS multi_caster_id_87, a3_.telephone AS telephone_88, a3_.siret AS siret_89, a3_.is_active AS is_active_90, a3_.eloa_ref AS eloa_ref_91, a3_.eloa_last_check AS eloa_last_check_92, a3_.eloa_statut AS eloa_statut_93, a3_.libelle AS libelle_94, a3_.reference_entite AS reference_entite_95, a3_.raison_sociale AS raison_sociale_96, a3_.ref_type_reseau AS ref_type_reseau_97, a3_.orias AS orias_98, a3_.description AS description_99, a3_.has_grey_card_service AS has_grey_card_service_100, a3_.slug AS slug_101, a3_.has_loyalty_program AS has_loyalty_program_102, a3_.has_up_my_shop AS has_up_my_shop_103, a3_.latitude AS latitude_104, a3_.longitude AS longitude_105, a3_.royalty_network_date AS royalty_network_date_106, a3_.royalty_remainder AS royalty_remainder_107, a3_.fiscal_code_it AS fiscal_code_it_108, a3_.leocare_id AS leocare_id_109, a3_.autoscout24_api_id AS autoscout24_api_id_110, a3_.up_my_shop_url AS up_my_shop_url_111, a3_.lacentrale_id AS lacentrale_id_112, a3_.has_annoncesautomobile AS has_annoncesautomobile_113, a3_.definitively_inactive AS definitively_inactive_114, a3_.first_contract_date AS first_contract_date_115, a3_.opening_date AS opening_date_116, a3_.vosfactures_id AS vosfactures_id_117, a3_.vosfactures_client_id AS vosfactures_client_id_118, a3_.grey_card_website AS grey_card_website_119, a3_.has_cps AS has_cps_120, a3_.contract_date AS contract_date_121, a3_.autoscout24_id AS autoscout24_id_122, a3_.paruvendu_id AS paruvendu_id_123, a3_.ouestfrance_id AS ouestfrance_id_124, a3_.atoutcoin_id AS atoutcoin_id_125, a3_.royalty_variable_date AS royalty_variable_date_126, a3_.royalty_communication_date AS royalty_communication_date_127, a3_.agency_migrated AS agency_migrated_128, a3_.facturation_id AS facturation_id_129, a3_.invoice_number AS invoice_number_130, a3_.address_number AS address_number_131, a3_.address_extension AS address_extension_132, a3_.address_street AS address_street_133, a3_.address AS address_134, a3_.created_at AS created_at_135, a3_.updated_at AS updated_at_136, b0_.bodywork_category_id AS bodywork_category_id_137, v2_.agency_id AS agency_id_138, v2_.transmission_id AS transmission_id_139, v2_.vehicle_type_id AS vehicle_type_id_140, v2_.critair_id AS critair_id_141, v2_.fuel_id AS fuel_id_142, v2_.model_id AS model_id_143, v2_.document_id AS document_id_144, v2_.user_id AS user_id_145, v2_.ambassador_id AS ambassador_id_146, v2_.archive_type_id AS archive_type_id_147, v2_.bodywork_id AS bodywork_id_148, v2_.buyer_id AS buyer_id_149, v2_.color_id AS color_id_150, v2_.euro_norm_id AS euro_norm_id_151, v2_.origin_id AS origin_id_152, v2_.workmate_registered_id AS workmate_registered_id_153, v2_.workmate_sold_id AS workmate_sold_id_154, v2_.vehicle_eloa_id AS vehicle_eloa_id_155, a3_.city_id AS city_id_156, a3_.company_id AS company_id_157, a3_.royalty_network_id AS royalty_network_id_158, a3_.royalty_communication_id AS royalty_communication_id_159, a3_.royalty_variable_id AS royalty_variable_id_160, a3_.close_reason_id AS close_reason_id_161 FROM bodywork b0_ INNER JOIN vehicle v2_ ON b0_.id = v2_.bodywork_id INNER JOIN agency a3_ ON v2_.agency_id = a3_.id LEFT JOIN ext_translations t1_ ON t1_.locale = 'de' AND t1_.field = 'name' AND t1_.object_class = 'App\\Entity\\Bodywork' AND t1_.foreign_key = b0_.id WHERE v2_.active IN (?) AND a3_.id IN (?) ORDER BY t1_.content ASC
Parameters: 
[
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.97 ms
(0.84%) 		1 
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.slug AS slug_2, f0_.ubiflow_id AS ubiflow_id_3, f0_.paruvendu_id AS paruvendu_id_4, f0_.lacentrale_id AS lacentrale_id_5, v1_.id AS id_6, v1_.finish AS finish_7, v1_.mileage AS mileage_8, v1_.in_service_date AS in_service_date_9, v1_.power AS power_10, v1_.power_din AS power_din_11, v1_.nb_door AS nb_door_12, v1_.nb_seat AS nb_seat_13, v1_.co2 AS co2_14, v1_.eloa_ref AS eloa_ref_15, v1_.eloa_statut AS eloa_statut_16, v1_.eloa_date_migration AS eloa_date_migration_17, v1_.active AS active_18, v1_.archive AS archive_19, v1_.archive_custom_reason AS archive_custom_reason_20, v1_.archived_at AS archived_at_21, v1_.brand_warranty_end_date AS brand_warranty_end_date_22, v1_.cantonal_annotation AS cantonal_annotation_23, v1_.chassis_number AS chassis_number_24, v1_.commission AS commission_25, v1_.created AS created_26, v1_.damaged AS damaged_27, v1_.damaged_description AS damaged_description_28, v1_.date_certificate_number_plate AS date_certificate_number_plate_29, v1_.description AS description_30, v1_.dual_key AS dual_key_31, v1_.engine_size AS engine_size_32, v1_.exclusive_sale AS exclusive_sale_33, v1_.financing_default_price AS financing_default_price_34, v1_.finish_leocare AS finish_leocare_35, v1_.formula_number_number_plate AS formula_number_number_plate_36, v1_.good_deal AS good_deal_37, v1_.horse_power AS horse_power_38, v1_.id_leocare AS id_leocare_39, v1_.interior AS interior_40, v1_.is_first_hand AS is_first_hand_41, v1_.is_leasing AS is_leasing_42, v1_.is_vat_recoverable AS is_vat_recoverable_43, v1_.is_yescar_repossession AS is_yescar_repossession_44, v1_.kw_power AS kw_power_45, v1_.last_revision_date AS last_revision_date_46, v1_.last_revision_description AS last_revision_description_47, v1_.last_revision_mileage AS last_revision_mileage_48, v1_.mileage_timing_belt AS mileage_timing_belt_49, v1_.min_price AS min_price_50, v1_.multicasted_elsewhere AS multicasted_elsewhere_51, v1_.multicasted_elsewhere_description AS multicasted_elsewhere_description_52, v1_.number_plate AS number_plate_53, v1_.original_price AS original_price_54, v1_.prestige AS prestige_55, v1_.price AS price_56, v1_.private_comment AS private_comment_57, v1_.reception_by_type AS reception_by_type_58, v1_.registration_number AS registration_number_59, v1_.seller_price AS seller_price_60, v1_.service_manual AS service_manual_61, v1_.size_rim AS size_rim_62, v1_.slug AS slug_63, v1_.technical_check_date AS technical_check_date_64, v1_.technical_check_description AS technical_check_description_65, v1_.timing_belt_description AS timing_belt_description_66, v1_.tire_back_left_description AS tire_back_left_description_67, v1_.tire_back_right_description AS tire_back_right_description_68, v1_.tire_front_left_description AS tire_front_left_description_69, v1_.tire_front_right_description AS tire_front_right_description_70, v1_.type_variant_version AS type_variant_version_71, v1_.under_sale_agreement AS under_sale_agreement_72, v1_.updated AS updated_73, v1_.use_as_security AS use_as_security_74, v1_.user_manual AS user_manual_75, v1_.warranty_duration AS warranty_duration_76, v1_.warranty_price AS warranty_price_77, v1_.workflow AS workflow_78, v1_.zip_archive AS zip_archive_79, v1_.has_lead_eloa AS has_lead_eloa_80, v1_.vehicle_migrated AS vehicle_migrated_81, v1_.eloa_updated_at AS eloa_updated_at_82, v1_.created_at AS created_at_83, v1_.updated_at AS updated_at_84, a2_.id AS id_85, a2_.name AS name_86, a2_.email AS email_87, a2_.multi_caster_id AS multi_caster_id_88, a2_.telephone AS telephone_89, a2_.siret AS siret_90, a2_.is_active AS is_active_91, a2_.eloa_ref AS eloa_ref_92, a2_.eloa_last_check AS eloa_last_check_93, a2_.eloa_statut AS eloa_statut_94, a2_.libelle AS libelle_95, a2_.reference_entite AS reference_entite_96, a2_.raison_sociale AS raison_sociale_97, a2_.ref_type_reseau AS ref_type_reseau_98, a2_.orias AS orias_99, a2_.description AS description_100, a2_.has_grey_card_service AS has_grey_card_service_101, a2_.slug AS slug_102, a2_.has_loyalty_program AS has_loyalty_program_103, a2_.has_up_my_shop AS has_up_my_shop_104, a2_.latitude AS latitude_105, a2_.longitude AS longitude_106, a2_.royalty_network_date AS royalty_network_date_107, a2_.royalty_remainder AS royalty_remainder_108, a2_.fiscal_code_it AS fiscal_code_it_109, a2_.leocare_id AS leocare_id_110, a2_.autoscout24_api_id AS autoscout24_api_id_111, a2_.up_my_shop_url AS up_my_shop_url_112, a2_.lacentrale_id AS lacentrale_id_113, a2_.has_annoncesautomobile AS has_annoncesautomobile_114, a2_.definitively_inactive AS definitively_inactive_115, a2_.first_contract_date AS first_contract_date_116, a2_.opening_date AS opening_date_117, a2_.vosfactures_id AS vosfactures_id_118, a2_.vosfactures_client_id AS vosfactures_client_id_119, a2_.grey_card_website AS grey_card_website_120, a2_.has_cps AS has_cps_121, a2_.contract_date AS contract_date_122, a2_.autoscout24_id AS autoscout24_id_123, a2_.paruvendu_id AS paruvendu_id_124, a2_.ouestfrance_id AS ouestfrance_id_125, a2_.atoutcoin_id AS atoutcoin_id_126, a2_.royalty_variable_date AS royalty_variable_date_127, a2_.royalty_communication_date AS royalty_communication_date_128, a2_.agency_migrated AS agency_migrated_129, a2_.facturation_id AS facturation_id_130, a2_.invoice_number AS invoice_number_131, a2_.address_number AS address_number_132, a2_.address_extension AS address_extension_133, a2_.address_street AS address_street_134, a2_.address AS address_135, a2_.created_at AS created_at_136, a2_.updated_at AS updated_at_137, v1_.agency_id AS agency_id_138, v1_.transmission_id AS transmission_id_139, v1_.vehicle_type_id AS vehicle_type_id_140, v1_.critair_id AS critair_id_141, v1_.fuel_id AS fuel_id_142, v1_.model_id AS model_id_143, v1_.document_id AS document_id_144, v1_.user_id AS user_id_145, v1_.ambassador_id AS ambassador_id_146, v1_.archive_type_id AS archive_type_id_147, v1_.bodywork_id AS bodywork_id_148, v1_.buyer_id AS buyer_id_149, v1_.color_id AS color_id_150, v1_.euro_norm_id AS euro_norm_id_151, v1_.origin_id AS origin_id_152, v1_.workmate_registered_id AS workmate_registered_id_153, v1_.workmate_sold_id AS workmate_sold_id_154, v1_.vehicle_eloa_id AS vehicle_eloa_id_155, a2_.city_id AS city_id_156, a2_.company_id AS company_id_157, a2_.royalty_network_id AS royalty_network_id_158, a2_.royalty_communication_id AS royalty_communication_id_159, a2_.royalty_variable_id AS royalty_variable_id_160, a2_.close_reason_id AS close_reason_id_161 FROM fuel f0_ INNER JOIN vehicle v1_ ON f0_.id = v1_.fuel_id INNER JOIN agency a2_ ON v1_.agency_id = a2_.id WHERE v1_.active IN (?) AND a2_.id IN (?) ORDER BY f0_.name ASC
Parameters: 
[
  true
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.64 ms
(0.55%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.multi_caster_id AS multi_caster_id_4, t0.telephone AS telephone_5, t0.siret AS siret_6, t0.is_active AS is_active_7, t0.eloa_ref AS eloa_ref_8, t0.eloa_last_check AS eloa_last_check_9, t0.eloa_statut AS eloa_statut_10, t0.libelle AS libelle_11, t0.reference_entite AS reference_entite_12, t0.raison_sociale AS raison_sociale_13, t0.ref_type_reseau AS ref_type_reseau_14, t0.orias AS orias_15, t0.description AS description_16, t0.has_grey_card_service AS has_grey_card_service_17, t0.slug AS slug_18, t0.has_loyalty_program AS has_loyalty_program_19, t0.has_up_my_shop AS has_up_my_shop_20, t0.latitude AS latitude_21, t0.longitude AS longitude_22, t0.royalty_network_date AS royalty_network_date_23, t0.royalty_remainder AS royalty_remainder_24, t0.fiscal_code_it AS fiscal_code_it_25, t0.leocare_id AS leocare_id_26, t0.autoscout24_api_id AS autoscout24_api_id_27, t0.up_my_shop_url AS up_my_shop_url_28, t0.lacentrale_id AS lacentrale_id_29, t0.has_annoncesautomobile AS has_annoncesautomobile_30, t0.definitively_inactive AS definitively_inactive_31, t0.first_contract_date AS first_contract_date_32, t0.opening_date AS opening_date_33, t0.vosfactures_id AS vosfactures_id_34, t0.vosfactures_client_id AS vosfactures_client_id_35, t0.grey_card_website AS grey_card_website_36, t0.has_cps AS has_cps_37, t0.contract_date AS contract_date_38, t0.autoscout24_id AS autoscout24_id_39, t0.paruvendu_id AS paruvendu_id_40, t0.ouestfrance_id AS ouestfrance_id_41, t0.atoutcoin_id AS atoutcoin_id_42, t0.royalty_variable_date AS royalty_variable_date_43, t0.royalty_communication_date AS royalty_communication_date_44, t0.agency_migrated AS agency_migrated_45, t0.facturation_id AS facturation_id_46, t0.invoice_number AS invoice_number_47, t0.address_number AS address_number_48, t0.address_extension AS address_extension_49, t0.address_street AS address_street_50, t0.address AS address_51, t0.created_at AS created_at_52, t0.updated_at AS updated_at_53, t0.city_id AS city_id_54, t0.company_id AS company_id_55, t0.royalty_network_id AS royalty_network_id_56, t0.royalty_communication_id AS royalty_communication_id_57, t0.royalty_variable_id AS royalty_variable_id_58, t0.close_reason_id AS close_reason_id_59 FROM agency t0 WHERE t0.slug = ? LIMIT 1
Parameters: 
[
  "ferney-voltaire"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.32 ms
(0.28%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.ntfy_id AS ntfy_id_6, t0.birthdate AS birthdate_7, t0.mobile_phone AS mobile_phone_8, t0.enabled AS enabled_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.is_male AS is_male_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.birth_name AS birth_name_15, t0.address_number AS address_number_16, t0.address_extension AS address_extension_17, t0.address_street AS address_street_18, t0.address AS address_19, t0.fixed_phone AS fixed_phone_20, t0.comment AS comment_21, t0.blacklist_mail AS blacklist_mail_22, t0.tax_number AS tax_number_23, t0.cps_id AS cps_id_24, t0.vosfactures_id AS vosfactures_id_25, t0.show_phone_multicaster AS show_phone_multicaster_26, t0.calendar_color AS calendar_color_27, t0.super_admin_confirmation AS super_admin_confirmation_28, t0.fiscal_code_it AS fiscal_code_it_29, t0.identity_card_number AS identity_card_number_30, t0.identity_card_date AS identity_card_date_31, t0.cps_form_token AS cps_form_token_32, t0.rsac AS rsac_33, t0.loyalty_card_number AS loyalty_card_number_34, t0.reset_token AS reset_token_35, t0.reset_token_created_at AS reset_token_created_at_36, t0.relaunch_date AS relaunch_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.reference_utilisateur AS reference_utilisateur_40, t0.reference_client AS reference_client_41, t0.reference_dosier AS reference_dosier_42, t0.id_dossier AS id_dossier_43, t0.date_accord_recueil_donnees_gerer_demande AS date_accord_recueil_donnees_gerer_demande_44, t0.date_accord_offres_commerciales_completer_demande AS date_accord_offres_commerciales_completer_demande_45, t0.date_accord_cession_coordonnees_partenaires_externes AS date_accord_cession_coordonnees_partenaires_externes_46, t0.date_sync AS date_sync_47, t0.ref_type_civilite AS ref_type_civilite_48, t0.ref_type_statut_utilisateur AS ref_type_statut_utilisateur_49, t0.image_id AS image_id_50, t0.document_id AS document_id_51, t0.city_id AS city_id_52, t0.birthplace_id AS birthplace_id_53, t0.confidential_document_id AS confidential_document_id_54, t0.identity_card_id AS identity_card_id_55, t0.company_id AS company_id_56, t0.entry_point_id AS entry_point_id_57, t0.relaunch_id AS relaunch_id_58 FROM user t0 INNER JOIN developer_agency ON t0.id = developer_agency.user_id WHERE developer_agency.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.30 ms
(0.26%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.ntfy_id AS ntfy_id_6, t0.birthdate AS birthdate_7, t0.mobile_phone AS mobile_phone_8, t0.enabled AS enabled_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.is_male AS is_male_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.birth_name AS birth_name_15, t0.address_number AS address_number_16, t0.address_extension AS address_extension_17, t0.address_street AS address_street_18, t0.address AS address_19, t0.fixed_phone AS fixed_phone_20, t0.comment AS comment_21, t0.blacklist_mail AS blacklist_mail_22, t0.tax_number AS tax_number_23, t0.cps_id AS cps_id_24, t0.vosfactures_id AS vosfactures_id_25, t0.show_phone_multicaster AS show_phone_multicaster_26, t0.calendar_color AS calendar_color_27, t0.super_admin_confirmation AS super_admin_confirmation_28, t0.fiscal_code_it AS fiscal_code_it_29, t0.identity_card_number AS identity_card_number_30, t0.identity_card_date AS identity_card_date_31, t0.cps_form_token AS cps_form_token_32, t0.rsac AS rsac_33, t0.loyalty_card_number AS loyalty_card_number_34, t0.reset_token AS reset_token_35, t0.reset_token_created_at AS reset_token_created_at_36, t0.relaunch_date AS relaunch_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.reference_utilisateur AS reference_utilisateur_40, t0.reference_client AS reference_client_41, t0.reference_dosier AS reference_dosier_42, t0.id_dossier AS id_dossier_43, t0.date_accord_recueil_donnees_gerer_demande AS date_accord_recueil_donnees_gerer_demande_44, t0.date_accord_offres_commerciales_completer_demande AS date_accord_offres_commerciales_completer_demande_45, t0.date_accord_cession_coordonnees_partenaires_externes AS date_accord_cession_coordonnees_partenaires_externes_46, t0.date_sync AS date_sync_47, t0.ref_type_civilite AS ref_type_civilite_48, t0.ref_type_statut_utilisateur AS ref_type_statut_utilisateur_49, t0.image_id AS image_id_50, t0.document_id AS document_id_51, t0.city_id AS city_id_52, t0.birthplace_id AS birthplace_id_53, t0.confidential_document_id AS confidential_document_id_54, t0.identity_card_id AS identity_card_id_55, t0.company_id AS company_id_56, t0.entry_point_id AS entry_point_id_57, t0.relaunch_id AS relaunch_id_58 FROM user t0 INNER JOIN agency_workmate ON t0.id = agency_workmate.user_id WHERE agency_workmate.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.25 ms
(0.22%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.active AS active_5, t0.ntfy_id AS ntfy_id_6, t0.birthdate AS birthdate_7, t0.mobile_phone AS mobile_phone_8, t0.enabled AS enabled_9, t0.confirmation_token AS confirmation_token_10, t0.password_requested_at AS password_requested_at_11, t0.is_male AS is_male_12, t0.first_name AS first_name_13, t0.last_name AS last_name_14, t0.birth_name AS birth_name_15, t0.address_number AS address_number_16, t0.address_extension AS address_extension_17, t0.address_street AS address_street_18, t0.address AS address_19, t0.fixed_phone AS fixed_phone_20, t0.comment AS comment_21, t0.blacklist_mail AS blacklist_mail_22, t0.tax_number AS tax_number_23, t0.cps_id AS cps_id_24, t0.vosfactures_id AS vosfactures_id_25, t0.show_phone_multicaster AS show_phone_multicaster_26, t0.calendar_color AS calendar_color_27, t0.super_admin_confirmation AS super_admin_confirmation_28, t0.fiscal_code_it AS fiscal_code_it_29, t0.identity_card_number AS identity_card_number_30, t0.identity_card_date AS identity_card_date_31, t0.cps_form_token AS cps_form_token_32, t0.rsac AS rsac_33, t0.loyalty_card_number AS loyalty_card_number_34, t0.reset_token AS reset_token_35, t0.reset_token_created_at AS reset_token_created_at_36, t0.relaunch_date AS relaunch_date_37, t0.created_at AS created_at_38, t0.updated_at AS updated_at_39, t0.reference_utilisateur AS reference_utilisateur_40, t0.reference_client AS reference_client_41, t0.reference_dosier AS reference_dosier_42, t0.id_dossier AS id_dossier_43, t0.date_accord_recueil_donnees_gerer_demande AS date_accord_recueil_donnees_gerer_demande_44, t0.date_accord_offres_commerciales_completer_demande AS date_accord_offres_commerciales_completer_demande_45, t0.date_accord_cession_coordonnees_partenaires_externes AS date_accord_cession_coordonnees_partenaires_externes_46, t0.date_sync AS date_sync_47, t0.ref_type_civilite AS ref_type_civilite_48, t0.ref_type_statut_utilisateur AS ref_type_statut_utilisateur_49, t0.image_id AS image_id_50, t0.document_id AS document_id_51, t0.city_id AS city_id_52, t0.birthplace_id AS birthplace_id_53, t0.confidential_document_id AS confidential_document_id_54, t0.identity_card_id AS identity_card_id_55, t0.company_id AS company_id_56, t0.entry_point_id AS entry_point_id_57, t0.relaunch_id AS relaunch_id_58 FROM user t0 INNER JOIN animator_agency ON t0.id = animator_agency.user_id WHERE animator_agency.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.21 ms
(0.18%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.url_logo AS url_logo_4, t0.code AS code_5 FROM gates t0 INNER JOIN agency_gates ON t0.id = agency_gates.gates_id WHERE agency_gates.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.20 ms
(0.17%) 		1 
SELECT t0.id AS id_1, t0.time_morning_begin AS time_morning_begin_2, t0.time_morning_end AS time_morning_end_3, t0.time_afternoon_begin AS time_afternoon_begin_4, t0.time_afternoon_end AS time_afternoon_end_5, t0.day_id AS day_id_6, t7.id AS id_8, t7.name AS name_9, t0.agency_id AS agency_id_10 FROM opening_hour t0 INNER JOIN day t7 ON t0.day_id = t7.id WHERE t0.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.15%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_number AS tax_number_3, t0.rcs AS rcs_4, t0.capital AS capital_5, t0.iban AS iban_6, t0.bic AS bic_7, t0.telephone AS telephone_8, t0.siret AS siret_9, t0.address_number AS address_number_10, t0.address_extension AS address_extension_11, t0.address_street AS address_street_12, t0.address AS address_13, t0.company_type_id AS company_type_id_14, t0.city_id AS city_id_15 FROM company t0 WHERE t0.id = ?
Parameters: 
[
  8628
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.14%) 		1 
SELECT t0.id AS id_1, t0.image AS image_2, t0.position AS position_3, t0.eloa_url AS eloa_url_4, t0.eloa_order AS eloa_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.agency_id AS agency_id_8, t0.vehicle_id AS vehicle_id_9 FROM image t0 WHERE t0.agency_id = ? ORDER BY t0.position ASC
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(0.14%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.percent AS percent_3 FROM royalty_variable t0 WHERE t0.id = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.13%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.insee_code AS insee_code_6, t0.department_id AS department_id_7 FROM city t0 WHERE t0.id = ?
Parameters: 
[
  28647
]
View formatted query    View runnable query    Explain query    View query backtrace
0.15 ms
(0.13%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3 FROM royalty_item t0 INNER JOIN agency_royalty_item ON t0.id = agency_royalty_item.royalty_item_id WHERE agency_royalty_item.agency_id = ?
Parameters: 
[
  251
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.12%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3 FROM royalty_network t0 WHERE t0.id = ?
Parameters: 
[
  14
]
View formatted query    View runnable query    Explain query    View query backtrace
0.14 ms
(0.12%) 		1 
SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.id = ?
Parameters: 
[
  75
]
View formatted query    View runnable query    Explain query    View query backtrace
0.13 ms
(0.12%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.postal_code AS postal_code_3, t0.country_id AS country_id_4 FROM department t0 WHERE t0.id = ?
Parameters: 
[
  77
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(0.11%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2 FROM company_type t0 WHERE t0.id = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
0.10 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.code AS code_2, t0.tax AS tax_3, t0.reference_eloa AS reference_eloa_4, t0.label AS label_5 FROM country t0 WHERE t0.code = ? LIMIT 1
Parameters: 
[
  "de"
]
View formatted query    View runnable query    Explain query    View query backtrace

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\User 34
App\Entity\Vehicle 32
App\Entity\Model 26
App\Entity\Make 17
App\Entity\Bodywork 8
App\Entity\Color 7
App\Entity\OpeningHour 7
App\Entity\Day 7
App\Entity\Country 5
App\Entity\City 4
App\Entity\Fuel 3
App\Entity\EuroNorm 3
App\Entity\Company 2
App\Entity\Transmission 2
App\Entity\Critair 2
App\Entity\EntryPoint 2
App\Entity\Agency 1
App\Entity\RoyaltyNetwork 1
App\Entity\RoyaltyVariable 1
App\Entity\Department 1
App\Entity\CompanyType 1
App\Entity\Image 1
App\Entity\Gates 1
App\Entity\VehicleType 1
App\Entity\BodyworkCategory 1
App\Entity\Document 1

Entities Mapping

Class Mapping errors
App\Entity\Country No errors.
App\Entity\Department No errors.
App\Entity\Agency No errors.
App\Entity\City No errors.
App\Entity\Company No errors.
App\Entity\RoyaltyNetwork No errors.
App\Entity\RoyaltyCommunication No errors.
App\Entity\RoyaltyVariable No errors.
App\Entity\CloseReason No errors.
App\Entity\Vehicle
  • The field App\Entity\Vehicle#saleAgreements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SaleAgreement#vehicle does not contain the required 'inversedBy="saleAgreements"' attribute.
  • The field App\Entity\Vehicle#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#vehicle does not contain the required 'inversedBy="invoices"' attribute.
App\Entity\OpeningHour No errors.
App\Entity\Image No errors.
App\Entity\User
  • The mappings App\Entity\User#relaunch and App\Entity\Relaunch#user are inconsistent with each other.
  • The field App\Entity\User#saleAgreements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SaleAgreement#user does not contain the required 'inversedBy="saleAgreements"' attribute.
  • The field App\Entity\User#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#user does not contain the required 'inversedBy="invoices"' attribute.
App\Entity\Eloa\ZoneIntervention No errors.
App\Entity\Eloa\TypeStatutProduit No errors.
App\Entity\Gates No errors.
App\Entity\RoyaltyItem No errors.
App\Entity\Image360 No errors.
App\Entity\CompanyType No errors.
App\Entity\SurveySatisfaction No errors.
App\Entity\Make No errors.
App\Entity\Model No errors.
App\Entity\Transmission No errors.
App\Entity\VehicleType No errors.
App\Entity\Critair No errors.
App\Entity\Fuel No errors.
App\Entity\Document No errors.
App\Entity\ArchiveType No errors.
App\Entity\Bodywork No errors.
App\Entity\Color No errors.
App\Entity\EuroNorm No errors.
App\Entity\Eloa\Vehicle\VehicleEloa No errors.
App\Entity\Equipment No errors.
App\Entity\Video No errors.
App\Entity\SaleAgreement No errors.
App\Entity\ExtraOption No errors.
App\Entity\Invoice No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
Gedmo\Translatable\Entity\Translation No errors.
App\Entity\BodyworkCategory No errors.
App\Entity\SEOBrandPage No errors.
App\Entity\Day No errors.
App\Entity\EntryPoint No errors.
App\Entity\Relaunch
  • The association App\Entity\Relaunch#user refers to the owning side field App\Entity\User#relance which does not exist.
App\Entity\Notification No errors.
App\Entity\Skill No errors.