Query Metrics
4
Database Queries
2
Different statements
2.06 ms
Query time
1
Invalid entities
3
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section AS section_3, t0.value AS value_4, t0.description AS description_5, t0.twig_parameters AS twig_parameters_6, t0.flag AS flag_7, t0.data_type AS data_type_8 FROM craue_settings t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"BEZAHL_TOKEN"
]
|
||||||||||||||||||||||
| 2 | 0.14 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section AS section_3, t0.value AS value_4, t0.description AS description_5, t0.twig_parameters AS twig_parameters_6, t0.flag AS flag_7, t0.data_type AS data_type_8 FROM craue_settings t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"SHOPPING_CART_CHECKOUT_TIMEOUT"
]
|
||||||||||||||||||||||
| 3 | 0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section AS section_3, t0.value AS value_4, t0.description AS description_5, t0.twig_parameters AS twig_parameters_6, t0.flag AS flag_7, t0.data_type AS data_type_8 FROM craue_settings t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"DISABLE_PURCHASE_OPTION"
]
|
||||||||||||||||||||||
| 4 | 1.33 ms |
SELECT t0.id AS id_1, t0.mobile_de_id AS mobile_de_id_2, t0.slug AS slug_3, t0.full_name AS full_name_4, t0.price AS price_5, t0.power AS power_6, t0.mileage AS mileage_7, t0.first_registration AS first_registration_8, t0.delivery_date AS delivery_date_9, t0.cubic_capacity AS cubic_capacity_10, t0.num_seats AS num_seats_11, t0.previous_owners AS previous_owners_12, t0.manufacturer_color_name AS manufacturer_color_name_13, t0.fuel_consumption_inner AS fuel_consumption_inner_14, t0.fuel_consumption_outer AS fuel_consumption_outer_15, t0.fuel_consumption_combined AS fuel_consumption_combined_16, t0.fuel_consumption_combined_wltp AS fuel_consumption_combined_wltp_17, t0.co2_emission AS co2_emission_18, t0.co2_emission_wltp AS co2_emission_wltp_19, t0.emission_class AS emission_class_20, t0.energy_efficiency_class AS energy_efficiency_class_21, t0.on_home_page AS on_home_page_22, t0.creating_method AS creating_method_23, t0.full_description AS full_description_24, t0.enriched_description AS enriched_description_25, t0.financing_example AS financing_example_26, t0.update_at AS update_at_27, t0.seller_inventory_key AS seller_inventory_key_28, t0.price_vatable AS price_vatable_29, t0.car_internal_panorama AS car_internal_panorama_30, t0.hire_purchase AS hire_purchase_31, t0.huau AS huau_32, t0.sale_status AS sale_status_33, t0.reserved_at AS reserved_at_34, t0.order_created_at AS order_created_at_35, t0.class_id AS class_id_36, t37.id AS id_38, t37.name AS name_39, t37.name_de AS name_de_40, t0.cat_id AS cat_id_41, t42.id AS id_43, t42.name AS name_44, t42.name_de AS name_de_45, t42.vehicle_class_id AS vehicle_class_id_46, t0.maker_id AS maker_id_47, t48.id AS id_49, t48.name AS name_50, t48.name_de AS name_de_51, t48.sel_group AS sel_group_52, t48.sort_key AS sort_key_53, t48.vehicle_class_id AS vehicle_class_id_54, t0.model_id AS model_id_55, t56.id AS id_57, t56.name AS name_58, t56.name_de AS name_de_59, t56.group_key AS group_key_60, t56.make_id AS make_id_61, t56.vehicle_class_id AS vehicle_class_id_62, t0.fuel_id AS fuel_id_63, t64.id AS id_65, t64.name AS name_66, t64.name_de AS name_de_67, t0.gearbox_id AS gearbox_id_68, t69.id AS id_70, t69.name AS name_71, t69.name_de AS name_de_72, t0.interior_type_id AS interior_type_id_73, t74.id AS id_75, t74.name AS name_76, t74.name_de AS name_de_77, t0.door_count_id AS door_count_id_78, t79.id AS id_80, t79.name AS name_81, t79.name_de AS name_de_82, t0.car_condition_id AS car_condition_id_83, t84.id AS id_85, t84.name AS name_86, t84.name_de AS name_de_87, t0.climatisation_id AS climatisation_id_88, t89.id AS id_90, t89.name AS name_91, t89.name_de AS name_de_92, t0.exterior_color_id AS exterior_color_id_93, t94.id AS id_95, t94.name AS name_96, t94.name_de AS name_de_97, t98.id AS id_99, t98.price AS price_100, t98.mileage AS mileage_101, t98.created_at AS created_at_102, t98.updated_at AS updated_at_103, t98.calculated_at AS calculated_at_104, t98.ads_id AS ads_id_105, t0.filial_id AS filial_id_106, t107.id AS id_108, t107.name AS name_109, t107.full_name AS full_name_110, t107.phone AS phone_111, t107.e_mail AS e_mail_112, t107.firm_name AS firm_name_113, t107.address AS address_114, t107.city AS city_115, t107.zip AS zip_116, t107.geo_position AS geo_position_117, t107.photo_file AS photo_file_118, t107.is_active AS is_active_119, t107.map_url AS map_url_120, t107.map_iframe AS map_iframe_121, t107.link_antragstrecke AS link_antragstrecke_122, t107.link_landingpage AS link_landingpage_123, t107.brand_logos AS brand_logos_124, t107.opening_hours AS opening_hours_125, t107.order_weight AS order_weight_126, t107.external_id AS external_id_127, t0.api_account_id AS api_account_id_128 FROM ads t0 LEFT JOIN ref_vehicle_classes t37 ON t0.class_id = t37.id LEFT JOIN ref_vehicle_categories t42 ON t0.cat_id = t42.id LEFT JOIN ref_vehicle_makers t48 ON t0.maker_id = t48.id LEFT JOIN ref_vehicle_models t56 ON t0.model_id = t56.id LEFT JOIN ref_fuel t64 ON t0.fuel_id = t64.id LEFT JOIN ref_gearbox t69 ON t0.gearbox_id = t69.id LEFT JOIN ref_interior_type t74 ON t0.interior_type_id = t74.id LEFT JOIN ref_door_count t79 ON t0.door_count_id = t79.id LEFT JOIN ref_condition t84 ON t0.car_condition_id = t84.id LEFT JOIN ref_climatisation t89 ON t0.climatisation_id = t89.id LEFT JOIN ref_color t94 ON t0.exterior_color_id = t94.id LEFT JOIN ads_comparison t98 ON t98.ads_id = t0.id LEFT JOIN filial t107 ON t0.filial_id = t107.id WHERE t0.slug = ? LIMIT 1
Parameters:
[
"MINI_Cooper_3_T_rer_LED_SPORTSITZ_KLIMA_PDC_SHZ_ALU_00004016525"
]
|
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 |
|---|---|
| CarSale\ClassicBundle\Entity\CraueSetting | 3 |