Query Metrics
9
Database Queries
9
Different statements
13.50 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.72 ms (20.11%) |
1 |
SELECT t0.main_title AS main_title_1, t0.main_text AS main_text_2, t0.main_quote_show AS main_quote_show_3, t0.main_quote_img AS main_quote_img_4, t0.main_quote_text AS main_quote_text_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.modified_at AS modified_at_8, t0.created_user AS created_user_9, t0.modified_user AS modified_user_10 FROM info_machine t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.83 ms (13.55%) |
1 |
SELECT m0_.title AS title_0, m0_.code_crm AS code_crm_1, m0_.slug AS slug_2, m0_.active AS active_3, m0_.active_home AS active_home_4, m0_.position AS position_5, m0_.img_list AS img_list_6, m0_.main_show AS main_show_7, m0_.main_prefix AS main_prefix_8, m0_.main_title AS main_title_9, m0_.main_img_bg1 AS main_img_bg1_10, m0_.main_img_bg2 AS main_img_bg2_11, m0_.main_img AS main_img_12, m0_.main_btn_text AS main_btn_text_13, m0_.rs_fb AS rs_fb_14, m0_.rs_tw AS rs_tw_15, m0_.rs_wts AS rs_wts_16, m0_.attr_show AS attr_show_17, m0_.attr_title AS attr_title_18, m0_.attr_items AS attr_items_19, m0_.attr_img_items AS attr_img_items_20, m0_.descrip_show AS descrip_show_21, m0_.descrip_title1 AS descrip_title1_22, m0_.descrip_text AS descrip_text_23, m0_.descrip_title2 AS descrip_title2_24, m0_.descrip_char_items AS descrip_char_items_25, m0_.descrip_items AS descrip_items_26, m0_.tec_show AS tec_show_27, m0_.tec_title AS tec_title_28, m0_.tec_brochure AS tec_brochure_29, m0_.tec_brochure_text AS tec_brochure_text_30, m0_.tec_items AS tec_items_31, m0_.gallery_show AS gallery_show_32, m0_.gallery_title AS gallery_title_33, m0_.gallery_items AS gallery_items_34, m0_.quote_show AS quote_show_35, m0_.quote_prefix AS quote_prefix_36, m0_.quote_title AS quote_title_37, m0_.quote_items AS quote_items_38, m0_.promise_show AS promise_show_39, m0_.promise_prefix AS promise_prefix_40, m0_.promise_title AS promise_title_41, m0_.promise_text AS promise_text_42, m0_.promise_logo AS promise_logo_43, m0_.promise_img AS promise_img_44, m0_.machines_show AS machines_show_45, m0_.machines_title AS machines_title_46, m0_.id AS id_47, m0_.created_at AS created_at_48, m0_.modified_at AS modified_at_49, m0_.created_user AS created_user_50, m0_.modified_user AS modified_user_51, c1_.title AS title_52, c1_.title_crm AS title_crm_53, c1_.slug AS slug_54, c1_.active AS active_55, c1_.active_menu AS active_menu_56, c1_.active_home AS active_home_57, c1_.description AS description_58, c1_.position AS position_59, c1_.logo AS logo_60, c1_.logo_color AS logo_color_61, c1_.id AS id_62, c1_.created_at AS created_at_63, c1_.modified_at AS modified_at_64, c1_.created_user AS created_user_65, c1_.modified_user AS modified_user_66, m0_.category_id AS category_id_67 FROM machine m0_ INNER JOIN category c1_ ON m0_.category_id = c1_.id WHERE m0_.active = 1 AND c1_.active = 1 AND c1_.slug = ? ORDER BY m0_.position ASC
Parameters:
[
"volquetes"
]
|
|
1.55 ms (11.46%) |
1 |
SELECT c0_.title AS title_0, c0_.title_crm AS title_crm_1, c0_.slug AS slug_2, c0_.active AS active_3, c0_.active_menu AS active_menu_4, c0_.active_home AS active_home_5, c0_.description AS description_6, c0_.position AS position_7, c0_.logo AS logo_8, c0_.logo_color AS logo_color_9, c0_.id AS id_10, c0_.created_at AS created_at_11, c0_.modified_at AS modified_at_12, c0_.created_user AS created_user_13, c0_.modified_user AS modified_user_14 FROM category c0_ INNER JOIN machine m1_ ON c0_.id = m1_.category_id WHERE c0_.active = 1 AND m1_.active = 1 AND c0_.slug = ? LIMIT 1
Parameters:
[
"volquetes"
]
|
|
1.54 ms (11.42%) |
1 |
SELECT c0_.title AS title_0, c0_.title_crm AS title_crm_1, c0_.slug AS slug_2, c0_.active AS active_3, c0_.active_menu AS active_menu_4, c0_.active_home AS active_home_5, c0_.description AS description_6, c0_.position AS position_7, c0_.logo AS logo_8, c0_.logo_color AS logo_color_9, c0_.id AS id_10, c0_.created_at AS created_at_11, c0_.modified_at AS modified_at_12, c0_.created_user AS created_user_13, c0_.modified_user AS modified_user_14 FROM category c0_ INNER JOIN machine m1_ ON c0_.id = m1_.category_id WHERE c0_.active = 1 AND m1_.active = 1 AND c0_.active_menu = 1 ORDER BY c0_.position ASC
Parameters:
[] |
|
1.38 ms (10.23%) |
1 |
SELECT s0_.title AS title_0, s0_.slug AS slug_1, s0_.active AS active_2, s0_.active_home AS active_home_3, s0_.active_menu AS active_menu_4, s0_.position AS position_5, s0_.img_home AS img_home_6, s0_.logo_home AS logo_home_7, s0_.logo_home_color AS logo_home_color_8, s0_.service_type_target AS service_type_target_9, s0_.service_type AS service_type_10, s0_.service_link AS service_link_11, s0_.service_wsp_num AS service_wsp_num_12, s0_.service_wsp_message AS service_wsp_message_13, s0_.main_prefix AS main_prefix_14, s0_.main_title AS main_title_15, s0_.main_descrip AS main_descrip_16, s0_.about_show AS about_show_17, s0_.about_items AS about_items_18, s0_.about_title AS about_title_19, s0_.promo_show AS promo_show_20, s0_.promo_url AS promo_url_21, s0_.promo_target AS promo_target_22, s0_.promo_img AS promo_img_23, s0_.promo_img_bg1 AS promo_img_bg1_24, s0_.form_text AS form_text_25, s0_.id AS id_26, s0_.created_at AS created_at_27, s0_.modified_at AS modified_at_28, s0_.created_user AS created_user_29, s0_.modified_user AS modified_user_30 FROM service s0_ WHERE s0_.active = 1 AND s0_.active_menu = 1 ORDER BY s0_.position ASC
Parameters:
[] |
|
1.26 ms (9.35%) |
1 |
SELECT t0.seo_indexing AS seo_indexing_1, t0.seo_favicon AS seo_favicon_2, t0.seo_title AS seo_title_3, t0.seo_description AS seo_description_4, t0.scripts_meta AS scripts_meta_5, t0.scripts_header AS scripts_header_6, t0.scripts_body AS scripts_body_7, t0.scripts_footer AS scripts_footer_8, t0.logo1_header AS logo1_header_9, t0.logo1_header_mobile AS logo1_header_mobile_10, t0.logo2_header AS logo2_header_11, t0.logo2_header_mobile AS logo2_header_mobile_12, t0.logo1_footer AS logo1_footer_13, t0.logo2_footer AS logo2_footer_14, t0.social_header_show AS social_header_show_15, t0.mnu_header_img AS mnu_header_img_16, t0.header_btn_show AS header_btn_show_17, t0.header_btn_text AS header_btn_text_18, t0.phone AS phone_19, t0.whatsapp AS whatsapp_20, t0.email AS email_21, t0.address_items AS address_items_22, t0.social_footer_text AS social_footer_text_23, t0.social_show AS social_show_24, t0.social_fb_show AS social_fb_show_25, t0.social_fb_url AS social_fb_url_26, t0.social_ld_show AS social_ld_show_27, t0.social_ld_url AS social_ld_url_28, t0.social_ig_show AS social_ig_show_29, t0.social_ig_url AS social_ig_url_30, t0.social_yt_url AS social_yt_url_31, t0.social_yt_show AS social_yt_show_32, t0.social_tt_url AS social_tt_url_33, t0.social_tt_show AS social_tt_show_34, t0.whatsapp_show AS whatsapp_show_35, t0.whatsapp_number AS whatsapp_number_36, t0.whatsapp_text AS whatsapp_text_37, t0.blog_show AS blog_show_38, t0.blog_url AS blog_url_39, t0.blog_qty AS blog_qty_40, t0.captcha_show AS captcha_show_41, t0.captcha_site AS captcha_site_42, t0.captcha_secret AS captcha_secret_43, t0.external_link_somenews AS external_link_somenews_44, t0.external_link_parts AS external_link_parts_45, t0.external_link_somenews_show AS external_link_somenews_show_46, t0.external_link_parts_show AS external_link_parts_show_47, t0.id AS id_48, t0.created_at AS created_at_49, t0.modified_at AS modified_at_50, t0.created_user AS created_user_51, t0.modified_user AS modified_user_52 FROM info t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
1.21 ms (9.00%) |
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/volquetes/"
]
|
|
1.04 ms (7.72%) |
1 |
SELECT t0.error_image AS error_image_1, t0.error_title AS error_title_2, t0.error_text AS error_text_3, t0.error_btn_text AS error_btn_text_4, t0.error_btn_url AS error_btn_url_5, t0.error_500_image AS error_500_image_6, t0.error_500_title AS error_500_title_7, t0.error_500_text AS error_500_text_8, t0.error_500_btn_text AS error_500_btn_text_9, t0.error_500_btn_url AS error_500_btn_url_10, t0.id AS id_11, t0.created_at AS created_at_12, t0.modified_at AS modified_at_13, t0.created_user AS created_user_14, t0.modified_user AS modified_user_15 FROM message_error t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.97 ms (7.17%) |
1 |
SELECT t0.quote_receiver AS quote_receiver_1, t0.service_receiver AS service_receiver_2, t0.machine_receiver AS machine_receiver_3, t0.promo_receiver AS promo_receiver_4, t0.parts_receiver AS parts_receiver_5, t0.customer_type AS customer_type_6, t0.document_types AS document_types_7, t0.origin_types AS origin_types_8, t0.store_types AS store_types_9, t0.claim_prefix AS claim_prefix_10, t0.claim_title AS claim_title_11, t0.claim_description AS claim_description_12, t0.claim_reason AS claim_reason_13, t0.claim_ruc AS claim_ruc_14, t0.claim_address AS claim_address_15, t0.claim_date AS claim_date_16, t0.claim_p1_title AS claim_p1_title_17, t0.claim_p2_title AS claim_p2_title_18, t0.claim_goods AS claim_goods_19, t0.claim_currencies AS claim_currencies_20, t0.claim_p3_title AS claim_p3_title_21, t0.claim_types AS claim_types_22, t0.claim_response_days AS claim_response_days_23, t0.claim_p4_title AS claim_p4_title_24, t0.claim_p4_text AS claim_p4_text_25, t0.claim_notes AS claim_notes_26, t0.claim_receiver AS claim_receiver_27, t0.gracias_banner AS gracias_banner_28, t0.gracias_logo AS gracias_logo_29, t0.gracias_texto AS gracias_texto_30, t0.gracias_titulo AS gracias_titulo_31, t0.email_imagen AS email_imagen_32, t0.email_titulo AS email_titulo_33, t0.email_texto AS email_texto_34, t0.email_asunto AS email_asunto_35, t0.id AS id_36, t0.created_at AS created_at_37, t0.modified_at AS modified_at_38, t0.created_user AS created_user_39, t0.modified_user AS modified_user_40 FROM forms 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\MessageError | No errors. |
| App\Entity\Service | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Forms | No errors. |
| App\Entity\Machine | No errors. |
| App\Entity\InfoMachine | No errors. |