Query Metrics
8
Database Queries
8
Different statements
10.25 ms
Query time
5
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.61 ms (25.45%) |
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, t1_.gallery_items AS gallery_items_12, t1_.characteristics_show AS characteristics_show_13, t1_.characteristics_items AS characteristics_items_14, t1_.description_show AS description_show_15, t1_.description_title AS description_title_16, t1_.description_text AS description_text_17, t1_.applications_show AS applications_show_18, t1_.applications_text AS applications_text_19, t1_.applications_items AS applications_items_20, t1_.attributes_show AS attributes_show_21, t1_.attributes_items AS attributes_items_22, t1_.technical_datasheet_show AS technical_datasheet_show_23, t1_.technical_datasheet_items AS technical_datasheet_items_24, t1_.technical_datasheet_file AS technical_datasheet_file_25, t1_.additional_show AS additional_show_26, t1_.additional_title AS additional_title_27, t1_.additional_items AS additional_items_28, m0_.dtype AS dtype_29, t1_.filter_model_id AS filter_model_id_30, t1_.filter_traction_id AS filter_traction_id_31, t1_.filter_type_id AS filter_type_id_32, t1_.filter_power_id AS filter_power_id_33, t1_.filter_tonnage_id AS filter_tonnage_id_34 FROM truck t1_ INNER JOIN model m0_ ON t1_.id = m0_.id INNER JOIN truck_filter_model t2_ ON t1_.filter_model_id = t2_.id INNER JOIN truck_filter_traction t3_ ON t1_.filter_traction_id = t3_.id INNER JOIN truck_filter_type t4_ ON t1_.filter_type_id = t4_.id INNER JOIN truck_filter_power t5_ ON t1_.filter_power_id = t5_.id INNER JOIN truck_filter_tonnage t6_ ON t1_.filter_tonnage_id = t6_.id WHERE m0_.active = 1 AND t2_.active = 1 AND t3_.active = 1 AND t4_.active = 1 AND t5_.active = 1 AND t6_.active = 1 AND m0_.in_home = 1 ORDER BY m0_.position ASC LIMIT 4
Parameters:
[] |
2.28 ms (22.22%) |
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_.in_home = 1 ORDER BY m0_.position ASC LIMIT 4
Parameters:
[] |
1.14 ms (11.11%) |
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.06 ms (10.31%) |
1 |
SELECT t0.banner AS banner_1, t0.trucks_show AS trucks_show_2, t0.trucks_title AS trucks_title_3, t0.trucks_button_title AS trucks_button_title_4, t0.trucks_button_target AS trucks_button_target_5, t0.buses_show AS buses_show_6, t0.buses_title AS buses_title_7, t0.buses_button_title AS buses_button_title_8, t0.buses_button_target AS buses_button_target_9, t0.detail_show AS detail_show_10, t0.detail_text AS detail_text_11, t0.detail_options AS detail_options_12, t0.detail_image AS detail_image_13, t0.blog_show AS blog_show_14, t0.blog_title AS blog_title_15, t0.blog_button_text AS blog_button_text_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.modified_at AS modified_at_19, t0.created_user AS created_user_20, t0.modified_user AS modified_user_21 FROM home t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.02 ms (9.96%) |
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:
[
"/"
]
|
0.82 ms (8.00%) |
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
]
|
0.73 ms (7.13%) |
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.60 ms (5.81%) |
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:
[] |
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\Dictionary | No errors. |
App\Entity\Seo | No errors. |
App\Entity\Info | No errors. |
App\Entity\Forms | No errors. |
App\Entity\Service | No errors. |
App\Entity\Models | No errors. |
App\Entity\Home | No errors. |
App\Entity\Model | No errors. |
App\Entity\Truck | No errors. |
App\Entity\Bus | No errors. |
App\Entity\TruckFilterModel |
|
App\Entity\TruckFilterTraction |
|
App\Entity\TruckFilterType |
|
App\Entity\TruckFilterPower |
|
App\Entity\TruckFilterTonnage |
|
App\Entity\BusFilterModel | No errors. |
App\Entity\BusFilterPBV | No errors. |
App\Entity\BusFilterPower | No errors. |
App\Entity\BusFilterTonnage | No errors. |