Query Metrics
87
Database Queries
21
Different statements
32.03 ms
Query time
2
Invalid entities
117
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6.39 ms (19.97%) |
23 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.type AS type_4, t0.slug AS slug_5, t0.field_values AS field_values_6, t0.groups AS groups_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.component_template_id AS component_template_id_10 FROM component_field t0 WHERE t0.id = ?
Parameters:
[
22
]
|
|
5.55 ms (17.33%) |
15 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.is_parent AS is_parent_4, t0.type AS type_5, t0.id_type AS id_type_6, t0.is_list AS is_list_7, t0.position AS position_8, t0.slug AS slug_9, t0.target AS target_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_id AS menu_id_13, t0.menu_item_parent_id AS menu_item_parent_id_14 FROM menu_item t0 WHERE t0.menu_item_parent_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
3.07 ms (9.59%) |
6 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.component_id AS component_id_5, t0.component_field_id AS component_field_id_6 FROM component_value t0 WHERE t0.component_id = ?
Parameters:
[
16172
]
|
|
1.92 ms (5.98%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.alt AS alt_4, t0.description AS description_5, t0.file AS file_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM file t0 WHERE t0.id = ?
Parameters:
[
"1595"
]
|
|
1.40 ms (4.38%) |
3 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.custom_classes AS custom_classes_3, t0.type AS type_4, t0.type_id AS type_id_5, t0.position AS position_6, t0.visibility_xs AS visibility_xs_7, t0.visibility_s AS visibility_s_8, t0.visibility_m AS visibility_m_9, t0.visibility_l AS visibility_l_10, t0.visibility_xl AS visibility_xl_11, t0.is_temp AS is_temp_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.component_template_id AS component_template_id_15, t0.parent_component_id AS parent_component_id_16 FROM component t0 WHERE t0.parent_component_id = ? ORDER BY t0.position ASC
Parameters:
[
16172
]
|
|
1.36 ms (4.25%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.short_description AS short_description_4, t0.is_container AS is_container_5, t0.prototype AS prototype_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM component_template t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
1.27 ms (3.96%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.is_parent AS is_parent_4, t0.type AS type_5, t0.id_type AS id_type_6, t0.is_list AS is_list_7, t0.position AS position_8, t0.slug AS slug_9, t0.target AS target_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menu_id AS menu_id_13, t0.menu_item_parent_id AS menu_item_parent_id_14 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
1.26 ms (3.92%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_id AS menu_id_7 FROM menu_area t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"menu-principal"
]
|
|
1.25 ms (3.89%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"fb"
]
|
|
1.21 ms (3.77%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.published AS published_4, t0.template AS template_5, t0.position AS position_6, t0.content AS content_7, t0.thumbnail AS thumbnail_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
|
1.14 ms (3.55%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t6.id AS id_7, t6.name AS name_8, t6.slug AS slug_9, t6.description AS description_10, t6.created_at AS created_at_11, t6.updated_at AS updated_at_12, t6.menu_id AS menu_id_13 FROM menu t0 LEFT JOIN menu_area t6 ON t6.menu_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.94 ms (2.92%) |
5 |
SELECT t0.id AS id_1, t0.site_title AS site_title_2, t0.favicon AS favicon_3, t0.site_logo AS site_logo_4, t0.back_main_color AS back_main_color_5, t0.has_posts AS has_posts_6, t0.has_archive_entities AS has_archive_entities_7, t0.has_single_entities AS has_single_entities_8, t0.has_seo_entities AS has_seo_entities_9, t0.agency_link AS agency_link_10, t0.agency_name AS agency_name_11, t0.recaptcha_public_key AS recaptcha_public_key_12, t0.recaptcha_private_key AS recaptcha_private_key_13, t0.homepage_id AS homepage_id_14 FROM core_options t0
Parameters:
[] |
|
0.90 ms (2.82%) |
1 |
SELECT t0.id AS id_1, t0.custom_id AS custom_id_2, t0.custom_classes AS custom_classes_3, t0.type AS type_4, t0.type_id AS type_id_5, t0.position AS position_6, t0.visibility_xs AS visibility_xs_7, t0.visibility_s AS visibility_s_8, t0.visibility_m AS visibility_m_9, t0.visibility_l AS visibility_l_10, t0.visibility_xl AS visibility_xl_11, t0.is_temp AS is_temp_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.component_template_id AS component_template_id_15, t0.parent_component_id AS parent_component_id_16 FROM component t0 WHERE t0.type = ? AND t0.type_id = ? AND t0.is_temp = ? AND t0.parent_component_id IS NULL ORDER BY t0.position ASC
Parameters:
[ "Page" 6 0 ] |
|
0.68 ms (2.12%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.type AS type_4, t0.position AS position_5, t0.col AS col_6, t0.is_required AS is_required_7, t0.options AS options_8, t0.contact_form_id AS contact_form_id_9 FROM contact_form_field t0 WHERE t0.contact_form_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.65 ms (2.04%) |
2 |
SELECT t0.id AS id_1, t0.has_builder_entities AS has_builder_entities_2 FROM builder_options t0
Parameters:
[] |
|
0.65 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.no_index AS no_index_4, t0.meta_robots AS meta_robots_5, t0.type AS type_6, t0.type_id AS type_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM seo t0 WHERE t0.type = ? AND t0.type_id = ? LIMIT 1
Parameters:
[ "Page" 6 ] |
|
0.63 ms (1.96%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.published AS published_4, t0.template AS template_5, t0.position AS position_6, t0.content AS content_7, t0.thumbnail AS thumbnail_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"contactez-nous"
]
|
|
0.61 ms (1.91%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.value AS value_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.option_category_id AS option_category_id_8 FROM `option` t0 WHERE t0.option_category_id = ?
Parameters:
[
1
]
|
|
0.50 ms (1.57%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM option_category t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"footer"
]
|
|
0.40 ms (1.24%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.mail AS mail_4, t0.form_to AS form_to_5, t0.form_object AS form_object_6, t0.template AS template_7 FROM contact_form t0 WHERE t0.id = ?
Parameters:
[
"1"
]
|
|
0.25 ms (0.77%) |
1 |
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.contact_mail AS contact_mail_3, t0.address AS address_4, t0.analytics_code AS analytics_code_5, t0.tag_manager_code AS tag_manager_code_6, t0.has_youtube_videos AS has_youtube_videos_7, t0.sopp_customer_id AS sopp_customer_id_8, t0.id_sir_data_user AS id_sir_data_user_9, t0.id_sir_data_site AS id_sir_data_site_10, t0.service_used AS service_used_11, t0.contact_page_id AS contact_page_id_12, t0.policy_page_id AS policy_page_id_13 FROM rgpd_options t0
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Akyos\BuilderBundle\Entity\ComponentValue | 36 |
| Akyos\BuilderBundle\Entity\ComponentField | 23 |
| Akyos\CoreBundle\Entity\MenuItem | 15 |
| Akyos\BuilderBundle\Entity\Component | 6 |
| Akyos\CoreBundle\Entity\Option | 6 |
| Akyos\CoreBundle\Entity\Page | 5 |
| Akyos\FormBundle\Entity\ContactFormField | 5 |
| Akyos\BuilderBundle\Entity\ComponentTemplate | 4 |
| Akyos\FileManagerBundle\Entity\File | 4 |
| Akyos\CoreBundle\Entity\MenuArea | 3 |
| Akyos\CoreBundle\Entity\Menu | 3 |
| Akyos\CoreBundle\Entity\OptionCategory | 2 |
| Akyos\BuilderBundle\Entity\BuilderOptions | 1 |
| Akyos\CoreBundle\Entity\Seo | 1 |
| Akyos\CoreBundle\Entity\CoreOptions | 1 |
| Akyos\CoreBundle\Entity\RgpdOptions | 1 |
| Akyos\FormBundle\Entity\ContactForm | 1 |