Query Metrics
10
Database Queries
10
Different statements
12.15 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.98 ms (32.75%) |
1 |
SELECT t0.title AS title_1, t0.image AS image_2, t0.attributes AS attributes_3, t0.data_sheet AS data_sheet_4, t0.active AS active_5, t0.position AS position_6, t0.slug AS slug_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.modified_at AS modified_at_10, t0.created_user AS created_user_11, t0.modified_user AS modified_user_12, t0.model_id AS model_id_13 FROM version t0 WHERE t0.model_id = ?
Parameters:
[
1
]
|
|
1.40 ms (11.53%) |
1 |
SELECT m0_.title AS title_0, m0_.crm_title AS crm_title_1, m0_.summary AS summary_2, m0_.logo AS logo_3, m0_.image AS image_4, m0_.banner_image AS banner_image_5, m0_.banner_text AS banner_text_6, m0_.detail_show AS detail_show_7, m0_.detail_title AS detail_title_8, m0_.detail_text AS detail_text_9, m0_.detail_image AS detail_image_10, m0_.specifications_show AS specifications_show_11, m0_.specifications_items AS specifications_items_12, m0_.attributes_show AS attributes_show_13, m0_.attributes_items AS attributes_items_14, m0_.gallery_show AS gallery_show_15, m0_.gallery_items AS gallery_items_16, m0_.versions_show AS versions_show_17, m0_.versions_title AS versions_title_18, m0_.form_image AS form_image_19, m0_.active AS active_20, m0_.position AS position_21, m0_.slug AS slug_22, m0_.id AS id_23, m0_.created_at AS created_at_24, m0_.modified_at AS modified_at_25, m0_.created_user AS created_user_26, m0_.modified_user AS modified_user_27 FROM model m0_ WHERE m0_.active = 1 AND m0_.slug = ? LIMIT 1
Parameters:
[
"croner-mke"
]
|
|
1.17 ms (9.62%) |
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:
[
"/camiones/croner-mke"
]
|
|
1.02 ms (8.39%) |
1 |
SELECT e0_.title AS title_0, e0_.address AS address_1, e0_.phones AS phones_2, e0_.emails AS emails_3, e0_.map_link AS map_link_4, e0_.active AS active_5, e0_.position AS position_6, e0_.slug AS slug_7, e0_.id AS id_8, e0_.created_at AS created_at_9, e0_.modified_at AS modified_at_10, e0_.created_user AS created_user_11, e0_.modified_user AS modified_user_12, e0_.department_id AS department_id_13, e0_.category_id AS category_id_14 FROM establishment e0_ INNER JOIN establishment_category e1_ ON e0_.category_id = e1_.id WHERE e0_.active = 1 AND e1_.active = 1 AND e1_.show_in_service_form = 1 ORDER BY e0_.position ASC
Parameters:
[] |
|
0.90 ms (7.41%) |
1 |
SELECT t0.phone AS phone_1, t0.email AS email_2, t0.header_logo AS header_logo_3, t0.header_logo_spare_parts AS header_logo_spare_parts_4, t0.header_logo_services AS header_logo_services_5, t0.footer_logo AS footer_logo_6, t0.sent_image AS sent_image_7, t0.sent_title_1 AS sent_title_1_8, t0.sent_title_2 AS sent_title_2_9, t0.sent_text AS sent_text_10, t0.sent_button_home_text AS sent_button_home_text_11, t0.sent_button_models_text AS sent_button_models_text_12, t0.error_image AS error_image_13, t0.error_title_1 AS error_title_1_14, t0.error_title_2 AS error_title_2_15, t0.error_text AS error_text_16, t0.error_button_home_text AS error_button_home_text_17, t0.error_button_models_text AS error_button_models_text_18, t0.error_404_image AS error_404_image_19, t0.error_404_title_1 AS error_404_title_1_20, t0.error_404_title_2 AS error_404_title_2_21, t0.error_404_text AS error_404_text_22, t0.error_404_button_home_text AS error_404_button_home_text_23, t0.error_404_button_models_text AS error_404_button_models_text_24, t0.social_whatsapp_show AS social_whatsapp_show_25, t0.social_whatsapp_number AS social_whatsapp_number_26, t0.social_whatsapp_message AS social_whatsapp_message_27, t0.social_facebook_show AS social_facebook_show_28, t0.social_facebook_link AS social_facebook_link_29, t0.social_linkedin_show AS social_linkedin_show_30, t0.social_linkedin_link AS social_linkedin_link_31, t0.social_instagram_show AS social_instagram_show_32, t0.social_instagram_link AS social_instagram_link_33, t0.social_youtube_show AS social_youtube_show_34, t0.social_youtube_link AS social_youtube_link_35, t0.social_blog_show AS social_blog_show_36, t0.social_blog_link AS social_blog_link_37, t0.seo_indexing AS seo_indexing_38, t0.seo_favicon AS seo_favicon_39, t0.seo_title AS seo_title_40, t0.seo_description AS seo_description_41, t0.captcha_show AS captcha_show_42, t0.captcha_site AS captcha_site_43, t0.captcha_secret AS captcha_secret_44, t0.scripts_meta AS scripts_meta_45, t0.scripts_header AS scripts_header_46, t0.scripts_body AS scripts_body_47, t0.scripts_footer AS scripts_footer_48, t0.id AS id_49, t0.created_at AS created_at_50, t0.modified_at AS modified_at_51, t0.created_user AS created_user_52, t0.modified_user AS modified_user_53 FROM info t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.85 ms (7.02%) |
1 |
SELECT m0_.title AS title_0, m0_.crm_title AS crm_title_1, m0_.summary AS summary_2, m0_.logo AS logo_3, m0_.image AS image_4, m0_.banner_image AS banner_image_5, m0_.banner_text AS banner_text_6, m0_.detail_show AS detail_show_7, m0_.detail_title AS detail_title_8, m0_.detail_text AS detail_text_9, m0_.detail_image AS detail_image_10, m0_.specifications_show AS specifications_show_11, m0_.specifications_items AS specifications_items_12, m0_.attributes_show AS attributes_show_13, m0_.attributes_items AS attributes_items_14, m0_.gallery_show AS gallery_show_15, m0_.gallery_items AS gallery_items_16, m0_.versions_show AS versions_show_17, m0_.versions_title AS versions_title_18, m0_.form_image AS form_image_19, m0_.active AS active_20, m0_.position AS position_21, m0_.slug AS slug_22, m0_.id AS id_23, m0_.created_at AS created_at_24, m0_.modified_at AS modified_at_25, m0_.created_user AS created_user_26, m0_.modified_user AS modified_user_27 FROM model m0_ WHERE m0_.active = 1 ORDER BY m0_.position ASC
Parameters:
[] |
|
0.78 ms (6.44%) |
1 |
SELECT t0.contact_receiver AS contact_receiver_1, t0.quotation_receiver AS quotation_receiver_2, t0.service_title AS service_title_3, t0.service_receiver AS service_receiver_4, t0.truck_title AS truck_title_5, t0.truck_subjects AS truck_subjects_6, t0.truck_receiver AS truck_receiver_7, t0.after_sales_title AS after_sales_title_8, t0.after_sales_receiver AS after_sales_receiver_9, t0.claim_title AS claim_title_10, t0.claim_text AS claim_text_11, t0.claim_establishments_items AS claim_establishments_items_12, t0.claim_establishments_text AS claim_establishments_text_13, t0.claim_establishments_note AS claim_establishments_note_14, t0.claim_p1_title AS claim_p1_title_15, t0.claim_p2_title AS claim_p2_title_16, t0.claim_goods AS claim_goods_17, t0.claim_p3_title AS claim_p3_title_18, t0.claim_types AS claim_types_19, t0.claim_p4_title AS claim_p4_title_20, t0.claim_response_days AS claim_response_days_21, t0.claim_description AS claim_description_22, t0.claim_p5_title AS claim_p5_title_23, t0.claim_notes AS claim_notes_24, t0.claim_receiver AS claim_receiver_25, t0.id AS id_26, t0.created_at AS created_at_27, t0.modified_at AS modified_at_28, t0.created_user AS created_user_29, t0.modified_user AS modified_user_30 FROM forms t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.75 ms (6.20%) |
1 |
SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.external_open AS external_open_2, s0_.external_link AS external_link_3, s0_.external_target AS external_target_4, s0_.banner_image AS banner_image_5, s0_.banner_text AS banner_text_6, s0_.detail_title AS detail_title_7, s0_.detail_text AS detail_text_8, s0_.contact_show AS contact_show_9, s0_.contact_title AS contact_title_10, s0_.contact_phone AS contact_phone_11, s0_.contact_email AS contact_email_12, s0_.contact_address AS contact_address_13, s0_.active AS active_14, s0_.in_header AS in_header_15, s0_.position AS position_16, s0_.slug AS slug_17, s0_.id AS id_18, s0_.created_at AS created_at_19, s0_.modified_at AS modified_at_20, s0_.created_user AS created_user_21, s0_.modified_user AS modified_user_22 FROM service s0_ WHERE s0_.active = 1 AND s0_.in_header = 1 ORDER BY s0_.position ASC
Parameters:
[] |
|
0.65 ms (5.38%) |
1 |
SELECT t0.title AS title_1, t0.icon AS icon_2, t0.active AS active_3, t0.show_in_service_form AS show_in_service_form_4, t0.position AS position_5, t0.slug AS slug_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.modified_at AS modified_at_9, t0.created_user AS created_user_10, t0.modified_user AS modified_user_11 FROM establishment_category t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.64 ms (5.24%) |
1 |
SELECT d0_.title AS title_0, d0_.message AS message_1, d0_.active AS active_2, d0_.position AS position_3, d0_.slug AS slug_4, d0_.id AS id_5, d0_.created_at AS created_at_6, d0_.modified_at AS modified_at_7, d0_.created_user AS created_user_8, d0_.modified_user AS modified_user_9 FROM department d0_ WHERE d0_.active = 1 ORDER BY d0_.title ASC, d0_.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\Department | No errors. |
| App\Entity\Establishment | No errors. |
| App\Entity\Model | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\EstablishmentCategory | No errors. |
| App\Entity\Version | No errors. |