Query Metrics
29
Database Queries
9
Different statements
33.64 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.45 ms |
SELECT t0.address AS address_1, t0.phone AS phone_2, t0.email AS email_3, t0.service_address AS service_address_4, t0.service_phone AS service_phone_5, t0.service_email AS service_email_6, t0.technical_assistance_address AS technical_assistance_address_7, t0.technical_assistance_phone AS technical_assistance_phone_8, t0.technical_assistance_email AS technical_assistance_email_9, t0.shop_active AS shop_active_10, t0.shop_button_text AS shop_button_text_11, t0.shop_link AS shop_link_12, t0.shop_target AS shop_target_13, t0.roulette_active AS roulette_active_14, t0.roulette_text AS roulette_text_15, t0.roulette_image AS roulette_image_16, t0.roulette_banner_home AS roulette_banner_home_17, t0.header_logo_color AS header_logo_color_18, t0.header_logo_white AS header_logo_white_19, t0.footer_logo AS footer_logo_20, t0.sent_image AS sent_image_21, t0.sent_title AS sent_title_22, t0.sent_text AS sent_text_23, t0.sent_button_home_text AS sent_button_home_text_24, t0.error_image AS error_image_25, t0.error_title AS error_title_26, t0.error_text AS error_text_27, t0.error_button_home_text AS error_button_home_text_28, t0.error_404_image AS error_404_image_29, t0.error_404_title AS error_404_title_30, t0.error_404_text AS error_404_text_31, t0.error_404_button_home_text AS error_404_button_home_text_32, t0.social_whatsapp_show AS social_whatsapp_show_33, t0.social_whatsapp_number AS social_whatsapp_number_34, t0.social_whatsapp_message AS social_whatsapp_message_35, t0.social_facebook_show AS social_facebook_show_36, t0.social_facebook_link AS social_facebook_link_37, t0.social_linkedin_show AS social_linkedin_show_38, t0.social_linkedin_link AS social_linkedin_link_39, t0.social_youtube_show AS social_youtube_show_40, t0.social_youtube_link AS social_youtube_link_41, t0.social_blog_show AS social_blog_show_42, t0.social_blog_link AS social_blog_link_43, t0.social_blog_categories AS social_blog_categories_44, t0.social_blog_posts AS social_blog_posts_45, t0.seo_indexing AS seo_indexing_46, t0.seo_favicon AS seo_favicon_47, t0.seo_title AS seo_title_48, t0.seo_description AS seo_description_49, t0.scripts_meta AS scripts_meta_50, t0.scripts_header AS scripts_header_51, t0.scripts_body AS scripts_body_52, t0.scripts_footer AS scripts_footer_53, t0.captcha_show AS captcha_show_54, t0.captcha_site AS captcha_site_55, t0.captcha_secret AS captcha_secret_56, t0.id AS id_57, t0.created_at AS created_at_58, t0.modified_at AS modified_at_59, t0.created_user AS created_user_60, t0.modified_user AS modified_user_61 FROM info t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2 | 0.88 ms |
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.technical_assistance_title AS technical_assistance_title_6, t0.technical_assistance_receiver AS technical_assistance_receiver_7, t0.promotion_receiver AS promotion_receiver_8, t0.application_receiver AS application_receiver_9, t0.truck_quotation_receiver AS truck_quotation_receiver_10, t0.service_quotation_title AS service_quotation_title_11, t0.service_quotation_receiver AS service_quotation_receiver_12, t0.claim_p1_title AS claim_p1_title_13, t0.claim_p2_title AS claim_p2_title_14, t0.claim_goods AS claim_goods_15, t0.claim_p3_title AS claim_p3_title_16, t0.claim_types AS claim_types_17, t0.claim_p4_title AS claim_p4_title_18, t0.claim_response_days AS claim_response_days_19, t0.claim_description AS claim_description_20, t0.claim_notes AS claim_notes_21, t0.claim_receiver AS claim_receiver_22, t0.id AS id_23, t0.created_at AS created_at_24, t0.modified_at AS modified_at_25, t0.created_user AS created_user_26, t0.modified_user AS modified_user_27 FROM forms t0 WHERE t0.id = ?
Parameters:
[
1
]
|
3 | 0.98 ms |
SELECT b0_.title AS title_0, b0_.open_external_link AS open_external_link_1, b0_.external_link AS external_link_2, b0_.banner_text AS banner_text_3, b0_.banner_image AS banner_image_4, b0_.banner_button_show AS banner_button_show_5, b0_.banner_button_text AS banner_button_text_6, b0_.banner_button_link AS banner_button_link_7, b0_.banner_button_target AS banner_button_target_8, b0_.detail_show AS detail_show_9, b0_.detail_title AS detail_title_10, b0_.detail_text AS detail_text_11, b0_.features_show AS features_show_12, b0_.features_items AS features_items_13, b0_.active AS active_14, b0_.position AS position_15, b0_.slug AS slug_16, b0_.id AS id_17, b0_.created_at AS created_at_18, b0_.modified_at AS modified_at_19, b0_.created_user AS created_user_20, b0_.modified_user AS modified_user_21 FROM brand b0_ WHERE b0_.active = 1 ORDER BY b0_.position ASC
Parameters:
[] |
4 | 0.91 ms |
SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.banner_image AS banner_image_2, s0_.banner_title AS banner_title_3, s0_.banner_text AS banner_text_4, s0_.detail_show AS detail_show_5, s0_.detail_title AS detail_title_6, s0_.detail_text AS detail_text_7, s0_.benefits_show AS benefits_show_8, s0_.benefits_title AS benefits_title_9, s0_.benefits_text AS benefits_text_10, s0_.benefits_image AS benefits_image_11, s0_.active AS active_12, s0_.in_header AS in_header_13, s0_.position AS position_14, s0_.slug AS slug_15, s0_.id AS id_16, s0_.created_at AS created_at_17, s0_.modified_at AS modified_at_18, s0_.created_user AS created_user_19, s0_.modified_user AS modified_user_20 FROM service s0_ WHERE s0_.active = 1 ORDER BY s0_.position ASC
Parameters:
[] |
5 | 1.23 ms |
SELECT s0_.title AS title_0, s0_.image AS image_1, s0_.banner_image AS banner_image_2, s0_.banner_title AS banner_title_3, s0_.banner_text AS banner_text_4, s0_.detail_show AS detail_show_5, s0_.detail_title AS detail_title_6, s0_.detail_text AS detail_text_7, s0_.benefits_show AS benefits_show_8, s0_.benefits_title AS benefits_title_9, s0_.benefits_text AS benefits_text_10, s0_.benefits_image AS benefits_image_11, s0_.active AS active_12, s0_.in_header AS in_header_13, s0_.position AS position_14, s0_.slug AS slug_15, s0_.id AS id_16, s0_.created_at AS created_at_17, s0_.modified_at AS modified_at_18, s0_.created_user AS created_user_19, s0_.modified_user AS modified_user_20 FROM service s0_ WHERE s0_.active = 1 AND s0_.slug = ? LIMIT 1
Parameters:
[
"servicio-postventa"
]
|
6 | 4.74 ms |
SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.type AS type_4, u0_.adviser_active AS adviser_active_5, u0_.password AS password_6 FROM user u0_ WHERE u0_.adviser_active = 1 AND u0_.type IN (?) ORDER BY u0_.name ASC
Parameters:
[ [ "adviser" "service_adviser" ] ] |
7 | 4.34 ms |
SELECT e0_.title AS title_0, e0_.address AS address_1, e0_.contacts AS contacts_2, e0_.link AS link_3, e0_.show_in_man AS show_in_man_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_.city_id AS city_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_form_quotation_services = 1 ORDER BY e1_.position ASC, e0_.position ASC
Parameters:
[] |
8 | 2.34 ms |
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:
[
"/servicio/servicio-postventa"
]
|
9 | 2.71 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
2
]
|
10 | 1.57 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
1
]
|
11 | 0.80 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
21
]
|
12 | 0.69 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
12
]
|
13 | 0.59 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
10
]
|
14 | 0.60 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
15
]
|
15 | 0.57 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
11
]
|
16 | 0.50 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
9
]
|
17 | 0.52 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
5
]
|
18 | 0.52 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
20
]
|
19 | 1.28 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
19
]
|
20 | 0.62 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
18
]
|
21 | 0.77 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
17
]
|
22 | 0.87 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
16
]
|
23 | 0.43 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
14
]
|
24 | 0.44 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
13
]
|
25 | 0.78 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
8
]
|
26 | 0.68 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
7
]
|
27 | 0.63 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
6
]
|
28 | 0.60 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
4
]
|
29 | 0.60 ms |
SELECT t0.title AS title_1, t0.active AS active_2, t0.position AS position_3, t0.slug AS slug_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.created_user AS created_user_8, t0.modified_user AS modified_user_9, t0.department_id AS department_id_10 FROM city t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Brand | No errors. |
App\Entity\Service | No errors. |
App\Entity\User | No errors. |
App\Entity\Establishment | No errors. |
App\Entity\FormQuotationServices | No errors. |
App\Entity\FormQuotationRequest | No errors. |
App\Entity\RequestService | No errors. |
App\Entity\RequestSparePart | No errors. |
App\Entity\EstablishmentCategory | No errors. |
App\Entity\City | No errors. |
App\Entity\Department | No errors. |