Query Metrics

8 Database Queries
8 Different statements
11.95 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.73 ms
(31.21%)
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.22 ms
(18.59%)
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.27 ms
(10.59%)
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
(8.89%)
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
]
1.01 ms
(8.48%)
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.99 ms
(8.33%)
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
]
0.88 ms
(7.34%)
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.78 ms
(6.56%)
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\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
  • The field App\Entity\TruckFilterModel#trucks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Truck#filter_model does not contain the required 'inversedBy="trucks"' attribute.
App\Entity\TruckFilterTraction
  • The field App\Entity\TruckFilterTraction#trucks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Truck#filter_traction does not contain the required 'inversedBy="trucks"' attribute.
App\Entity\TruckFilterType
  • The field App\Entity\TruckFilterType#trucks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Truck#filter_type does not contain the required 'inversedBy="trucks"' attribute.
App\Entity\TruckFilterPower
  • The field App\Entity\TruckFilterPower#trucks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Truck#filter_power does not contain the required 'inversedBy="trucks"' attribute.
App\Entity\TruckFilterTonnage
  • The field App\Entity\TruckFilterTonnage#trucks is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Truck#filter_tonnage does not contain the required 'inversedBy="trucks"' attribute.
App\Entity\BusFilterModel No errors.
App\Entity\BusFilterPBV No errors.
App\Entity\BusFilterPower No errors.
App\Entity\BusFilterTonnage No errors.