Query Metrics
6
Database Queries
6
Different statements
5.14 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.16 ms (22.65%) |
1 |
SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.shop_active AS shop_active_4, t0.shop_button_text AS shop_button_text_5, t0.shop_link AS shop_link_6, t0.shop_target AS shop_target_7, t0.roulette_active AS roulette_active_8, t0.roulette_link AS roulette_link_9, t0.roulette_text AS roulette_text_10, t0.roulette_image AS roulette_image_11, t0.roulette_banner_home AS roulette_banner_home_12, t0.roulette_target AS roulette_target_13, t0.header_logo_color AS header_logo_color_14, t0.header_logo_white AS header_logo_white_15, t0.footer_logo AS footer_logo_16, t0.link_buses AS link_buses_17, t0.link_services AS link_services_18, t0.link_spare_parts AS link_spare_parts_19, t0.link_spare_parts_warranty AS link_spare_parts_warranty_20, t0.link_online_store AS link_online_store_21, t0.link_technical_assistance AS link_technical_assistance_22, t0.link_after_sales_trucks AS link_after_sales_trucks_23, t0.link_after_sales_buses AS link_after_sales_buses_24, t0.link_claim_trucks AS link_claim_trucks_25, t0.link_claim_buses AS link_claim_buses_26, t0.sent_title AS sent_title_27, t0.sent_text AS sent_text_28, t0.sent_button_home_text AS sent_button_home_text_29, t0.sent_button_models_text AS sent_button_models_text_30, t0.error_title AS error_title_31, t0.error_text AS error_text_32, t0.error_button_home_text AS error_button_home_text_33, t0.error_button_models_text AS error_button_models_text_34, t0.error_404_title AS error_404_title_35, t0.error_404_text AS error_404_text_36, t0.error_404_button_home_text AS error_404_button_home_text_37, t0.error_404_button_models_text AS error_404_button_models_text_38, t0.social_whatsapp_show AS social_whatsapp_show_39, t0.social_whatsapp_number AS social_whatsapp_number_40, t0.social_whatsapp_message AS social_whatsapp_message_41, t0.social_facebook_show AS social_facebook_show_42, t0.social_facebook_link AS social_facebook_link_43, t0.social_linkedin_show AS social_linkedin_show_44, t0.social_linkedin_link AS social_linkedin_link_45, t0.social_youtube_show AS social_youtube_show_46, t0.social_youtube_link AS social_youtube_link_47, t0.social_blog_show AS social_blog_show_48, t0.social_blog_link AS social_blog_link_49, t0.social_blog_categories AS social_blog_categories_50, t0.social_blog_posts AS social_blog_posts_51, t0.seo_indexing AS seo_indexing_52, t0.seo_favicon AS seo_favicon_53, t0.seo_title AS seo_title_54, t0.seo_description AS seo_description_55, t0.scripts_meta AS scripts_meta_56, t0.scripts_header AS scripts_header_57, t0.scripts_body AS scripts_body_58, t0.scripts_footer AS scripts_footer_59, t0.captcha_show AS captcha_show_60, t0.captcha_site AS captcha_site_61, t0.captcha_secret AS captcha_secret_62, t0.id AS id_63, t0.created_at AS created_at_64, t0.modified_at AS modified_at_65, t0.created_user AS created_user_66, t0.modified_user AS modified_user_67 FROM info t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.05 ms (20.34%) |
1 |
SELECT m0_.title AS title_0, m0_.crm_title AS crm_title_1, m0_.image AS image_2, m0_.active AS active_3, m0_.in_home AS in_home_4, m0_.position AS position_5, m0_.slug AS slug_6, m0_.id AS id_7, m0_.created_at AS created_at_8, m0_.modified_at AS modified_at_9, m0_.created_user AS created_user_10, m0_.modified_user AS modified_user_11, b1_.link AS link_12, b1_.gallery_items AS gallery_items_13, b1_.characteristics_show AS characteristics_show_14, b1_.characteristics_items AS characteristics_items_15, b1_.description_show AS description_show_16, b1_.description_title AS description_title_17, b1_.description_text AS description_text_18, b1_.applications_show AS applications_show_19, b1_.applications_text AS applications_text_20, b1_.applications_items AS applications_items_21, b1_.attributes_show AS attributes_show_22, b1_.attributes_items AS attributes_items_23, b1_.technical_datasheet_show AS technical_datasheet_show_24, b1_.technical_datasheet_items AS technical_datasheet_items_25, b1_.technical_datasheet_file AS technical_datasheet_file_26, b1_.additional_show AS additional_show_27, b1_.additional_title AS additional_title_28, b1_.additional_items AS additional_items_29, m0_.dtype AS dtype_30, b1_.filter_model_id AS filter_model_id_31, b1_.filter_pbv_id AS filter_pbv_id_32, b1_.filter_power_id AS filter_power_id_33, b1_.filter_tonnage_id AS filter_tonnage_id_34 FROM bus b1_ INNER JOIN model m0_ ON b1_.id = m0_.id INNER JOIN bus_filter_model b2_ ON b1_.filter_model_id = b2_.id INNER JOIN bus_filter_pbv b3_ ON b1_.filter_pbv_id = b3_.id INNER JOIN bus_filter_power b4_ ON b1_.filter_power_id = b4_.id INNER JOIN bus_filter_tonnage b5_ ON b1_.filter_tonnage_id = b5_.id WHERE m0_.active = 1 AND b2_.active = 1 AND b3_.active = 1 AND b5_.active = 1 AND b4_.active = 1 AND m0_.slug = ? LIMIT 1
Parameters:
[
"17-210-od-gnv"
]
|
0.90 ms (17.56%) |
1 |
SELECT t0.indexing AS indexing_1, t0.path AS path_2, t0.title AS title_3, t0.description AS description_4, t0.social_title AS social_title_5, t0.social_description AS social_description_6, t0.social_image AS social_image_7, t0.scripts_meta AS scripts_meta_8, t0.scripts_header AS scripts_header_9, t0.scripts_body AS scripts_body_10, t0.scripts_footer AS scripts_footer_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM seo t0 WHERE t0.path = ? LIMIT 1
Parameters:
[
"/bus/17-210-od-gnv"
]
|
0.76 ms (14.70%) |
1 |
SELECT t0.document_types AS document_types_1, t0.contact_title AS contact_title_2, t0.contact_text AS contact_text_3, t0.contact_types AS contact_types_4, t0.contact_receiver AS contact_receiver_5, t0.promotion_receiver AS promotion_receiver_6, t0.application_receiver AS application_receiver_7, t0.truck_quotation_receiver AS truck_quotation_receiver_8, t0.bus_quotation_receiver AS bus_quotation_receiver_9, t0.service_quotation_title AS service_quotation_title_10, t0.service_quotation_receiver AS service_quotation_receiver_11, t0.id AS id_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.created_user AS created_user_15, t0.modified_user AS modified_user_16 FROM forms t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.64 ms (12.46%) |
1 |
SELECT s0_.title AS title_0, s0_.link AS link_1, s0_.active AS active_2, s0_.position AS position_3, s0_.id AS id_4, s0_.created_at AS created_at_5, s0_.modified_at AS modified_at_6, s0_.created_user AS created_user_7, s0_.modified_user AS modified_user_8 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC
Parameters:
[] |
0.63 ms (12.29%) |
1 |
SELECT t0.banner_desktop AS banner_desktop_1, t0.banner_tablet AS banner_tablet_2, t0.banner_mobile AS banner_mobile_3, t0.return_link AS return_link_4, t0.return_target AS return_target_5, t0.both_title AS both_title_6, t0.both_image AS both_image_7, t0.both_image_hover AS both_image_hover_8, t0.both_description AS both_description_9, t0.trucks_title AS trucks_title_10, t0.trucks_image AS trucks_image_11, t0.trucks_image_hover AS trucks_image_hover_12, t0.trucks_description AS trucks_description_13, t0.buses_title AS buses_title_14, t0.buses_image AS buses_image_15, t0.buses_image_hover AS buses_image_hover_16, t0.buses_description AS buses_description_17, t0.advertising_show AS advertising_show_18, t0.advertising_image AS advertising_image_19, t0.advertising_link AS advertising_link_20, t0.advertising_target AS advertising_target_21, t0.id AS id_22, t0.created_at AS created_at_23, t0.modified_at AS modified_at_24, t0.created_user AS created_user_25, t0.modified_user AS modified_user_26 FROM models t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Info | No errors. |
App\Entity\Dictionary | No errors. |
App\Entity\Seo | No errors. |
App\Entity\Forms | No errors. |
App\Entity\Service | No errors. |
App\Entity\Models | No errors. |
App\Entity\Model | No errors. |
App\Entity\Bus | No errors. |
App\Entity\BusFilterModel | No errors. |
App\Entity\BusFilterPBV | No errors. |
App\Entity\BusFilterPower | No errors. |
App\Entity\BusFilterTonnage | No errors. |