Query Metrics
75
Database Queries
19
Different statements
39.85 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
11.51 ms (28.89%) |
22 |
SELECT t0.id AS id_1, t0.menu_title AS menu_title_2, t0.locale AS locale_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7, t0._type, t0.section_tab_title AS section_tab_title_8, t0.section_link AS section_link_9, t0.section_tab_image AS section_tab_image_10, t0.product_section_tab_title AS product_section_tab_title_11, t0.product_section_tab_image AS product_section_tab_image_12, t0.link_link AS link_link_13, t0.link_target_blank AS link_target_blank_14 FROM moka_menu_main t0 WHERE t0.parent_id = ? AND t0._type IN ('main', 'mainsection', 'mainproductsection', 'mainlink') ORDER BY t0.position ASC
Parameters:
[
48
]
|
|
9.39 ms (23.57%) |
24 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_folder AS is_folder_3, t0.slug AS slug_4, t0.path AS path_5, t0.type AS type_6, t0.mime_type AS mime_type_7, t0.extension AS extension_8, t0.size AS size_9, t0.metadata AS metadata_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.parent_id AS parent_id_13 FROM moka_media_media t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2.41 ms (6.05%) |
1 |
SELECT m0_.internal_name AS internal_name_0, m0_.status AS status_1, m0_.mode AS mode_2, m0_.locales AS locales_3, m0_.id AS id_4, m0_.created_at AS created_at_5, m0_.updated_at AS updated_at_6, m1_.header_mode AS header_mode_7, m0_._entry_type AS _entry_type_8, m0_.parent_id AS parent_id_9, m1_.header_image_desktop AS header_image_desktop_10, m1_.header_image_mobile AS header_image_mobile_11, m1_.insert_image AS insert_image_12 FROM moka_entry_homepage m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id LEFT JOIN moka_entry_homepage_translation m2_ ON m1_.id = m2_.translatable_id WHERE m0_.mode = ? AND m2_.locale = ?
Parameters:
[ "main" "en_GB" ] |
|
1.94 ms (4.86%) |
3 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.header_mode AS header_mode_9, t1.parent_id AS parent_id_10, t0.header_image_desktop AS header_image_desktop_11, t0.header_image_mobile AS header_image_mobile_12, t0.insert_image AS insert_image_13, t1._entry_type FROM moka_entry_homepage t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.mode = ? AND t1.status = ? LIMIT 1
Parameters:
[ "main" "published" ] |
|
1.84 ms (4.61%) |
5 |
SELECT t0.id AS id_1, t0.menu_title AS menu_title_2, t0.locale AS locale_3, t0.position AS position_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.parent_id AS parent_id_7, t0._type, t0.column_link AS column_link_8, t0.link_link AS link_link_9 FROM moka_menu_footer t0 WHERE t0.parent_id = ? AND t0._type IN ('footer', 'footercolumn', 'footerlink') ORDER BY t0.position ASC
Parameters:
[
43
]
|
|
1.70 ms (4.26%) |
2 |
SELECT m0_.id AS id_0, m0_.menu_title AS menu_title_1, m0_.locale AS locale_2, m0_.position AS position_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.section_tab_title AS section_tab_title_6, m0_.section_link AS section_link_7, m0_.product_section_tab_title AS product_section_tab_title_8, m0_.link_link AS link_link_9, m0_.link_target_blank AS link_target_blank_10, m0_._type AS _type_11, m0_.parent_id AS parent_id_12, m0_.section_tab_image AS section_tab_image_13, m0_.product_section_tab_image AS product_section_tab_image_14 FROM moka_menu_main m0_ WHERE (m0_.locale = ? AND m0_.parent_id IS NULL) AND m0_._type IN ('main', 'mainsection', 'mainproductsection', 'mainlink') ORDER BY m0_.position ASC
Parameters:
[
"en_GB"
]
|
|
1.60 ms (4.02%) |
2 |
SELECT m0_.id AS id_0, m0_.menu_title AS menu_title_1, m0_.locale AS locale_2, m0_.position AS position_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.link_link AS link_link_6, m0_._type AS _type_7, m0_.parent_id AS parent_id_8, m0_.link_picto AS link_picto_9 FROM moka_menu_top m0_ WHERE (m0_.locale = ? AND m0_.parent_id IS NULL) AND m0_._type IN ('top', 'toplink') ORDER BY m0_.position ASC
Parameters:
[
"en_GB"
]
|
|
1.23 ms (3.09%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.button_link AS button_link_4, t0.button_text AS button_text_5, t0.body AS body_6, t0.slug AS slug_7, t0.seo AS seo_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.locale AS locale_11, t0.thematic AS thematic_12, t0.translatable_id AS translatable_id_13 FROM moka_entry_news_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
101
]
|
|
0.96 ms (2.42%) |
2 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.parent_id AS parent_id_9, t1._entry_type FROM moka_entry_thematic t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
91
]
|
|
0.90 ms (2.25%) |
1 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t0.published_at AS published_at_9, t0.tutorial AS tutorial_10, t1.parent_id AS parent_id_11, t0.image_header AS image_header_12, t1._entry_type FROM moka_entry_news t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.id IN (?, ?)
Parameters:
[ 101 102 ] |
|
0.87 ms (2.17%) |
1 |
SELECT t0.id AS id_1, t0.header_title AS header_title_2, t0.header_button_link AS header_button_link_3, t0.header_button_text AS header_button_text_4, t0.design_title AS design_title_5, t0.design_summary AS design_summary_6, t0.designs AS designs_7, t0.store_locator_title AS store_locator_title_8, t0.store_locator_button_link AS store_locator_button_link_9, t0.store_locator_button_text AS store_locator_button_text_10, t0.insert_title AS insert_title_11, t0.insert_subtitle AS insert_subtitle_12, t0.insert_button_link AS insert_button_link_13, t0.insert_button_text AS insert_button_text_14, t0.advantage_title AS advantage_title_15, t0.advantage_summary AS advantage_summary_16, t0.advantage_button_link AS advantage_button_link_17, t0.advantage_button_text AS advantage_button_text_18, t0.advantages AS advantages_19, t0.counsel_ontitle AS counsel_ontitle_20, t0.counsel_title AS counsel_title_21, t0.counsel_news AS counsel_news_22, t0.achievement_ontitle AS achievement_ontitle_23, t0.achievement_title AS achievement_title_24, t0.achievement_button_link AS achievement_button_link_25, t0.achievement_button_text AS achievement_button_text_26, t0.achievements AS achievements_27, t0.seo AS seo_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.locale AS locale_31, t0.translatable_id AS translatable_id_32 FROM moka_entry_homepage_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.86 ms (2.15%) |
1 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.parent_id AS parent_id_9, t0.image_header AS image_header_10, t1._entry_type FROM moka_entry_affiliate t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.mode = ? AND t1.status = ? LIMIT 1
Parameters:
[ "main" "published" ] |
|
0.81 ms (2.04%) |
2 |
SELECT m0_.id AS id_0, m0_.menu_title AS menu_title_1, m0_.locale AS locale_2, m0_.position AS position_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.column_link AS column_link_6, m0_.link_link AS link_link_7, m0_._type AS _type_8, m0_.parent_id AS parent_id_9 FROM moka_menu_footer m0_ WHERE (m0_.locale = ? AND m0_.parent_id IS NULL) AND m0_._type IN ('footer', 'footercolumn', 'footerlink') ORDER BY m0_.position ASC
Parameters:
[
"en_GB"
]
|
|
0.78 ms (1.94%) |
1 |
SELECT t0.id AS id_1, t0.promo_header_enable AS promo_header_enable_2, t0.promo_header_text AS promo_header_text_3, t0.promo_header_bold_text AS promo_header_bold_text_4, t0.promo_header_link_text AS promo_header_link_text_5, t0.promo_header_link AS promo_header_link_6, t0.google_maps_api_key AS google_maps_api_key_7, t0.robots AS robots_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM moka_variable_variable t0 LIMIT 1
Parameters:
[] |
|
0.77 ms (1.94%) |
2 |
SELECT m0_.id AS id_0, m0_.menu_title AS menu_title_1, m0_.locale AS locale_2, m0_.position AS position_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.link_link AS link_link_6, m0_._type AS _type_7, m0_.parent_id AS parent_id_8 FROM moka_menu_last_footer m0_ WHERE (m0_.locale = ? AND m0_.parent_id IS NULL) AND m0_._type IN ('lastfooter', 'lastfooterlink') ORDER BY m0_.position ASC
Parameters:
[
"en_GB"
]
|
|
0.75 ms (1.89%) |
1 |
SELECT t0.id AS id_1, t0.header_affiliate_label AS header_affiliate_label_2, t0.header_affiliate_link AS header_affiliate_link_3, t0.footer_address AS footer_address_4, t0.footer_phone AS footer_phone_5, t0.footer_facebook AS footer_facebook_6, t0.footer_instagram AS footer_instagram_7, t0.tac_privacy_url AS tac_privacy_url_8, t0.product_recovery_page AS product_recovery_page_9, t0.reassurances AS reassurances_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.locale AS locale_13, t0.header_catalog AS header_catalog_14, t0.translatable_id AS translatable_id_15 FROM moka_variable_variable_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
1
]
|
|
0.65 ms (1.63%) |
1 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.parent_id AS parent_id_9, t1._entry_type FROM moka_entry_news_list t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.mode = ? AND t1.status = ? LIMIT 1
Parameters:
[ "main" "published" ] |
|
0.47 ms (1.17%) |
1 |
SELECT t1.internal_name AS internal_name_2, t1.status AS status_3, t1.mode AS mode_4, t1.locales AS locales_5, t1.id AS id_6, t1.created_at AS created_at_7, t1.updated_at AS updated_at_8, t1.parent_id AS parent_id_9, t1._entry_type FROM moka_entry_contact t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.mode = ? AND t1.status = ? LIMIT 1
Parameters:
[ "main" "published" ] |
|
0.42 ms (1.05%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.seo AS seo_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM moka_entry_contact_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
5
]
|
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 |
|---|---|
| Moka\Cms\Entity\Reference | No errors. |
| App\Entity\AffiliateRequest | No errors. |
| App\Entity\ContactRequest | No errors. |
| Moka\Cms\Entity\Entry | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Homepage | No errors. |
| Moka\Cms\GeneratedEntity\Entry\HomepageTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Media\Media | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Affiliate | No errors. |
| Moka\Cms\GeneratedEntity\Entry\AffiliateTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Variable\Variable | No errors. |
| Moka\Cms\GeneratedEntity\Variable\VariableTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Menu\Top | No errors. |
| Moka\Cms\GeneratedEntity\Menu\TopLink | No errors. |
| Moka\Cms\GeneratedEntity\Menu\Main | No errors. |
| Moka\Cms\GeneratedEntity\Menu\MainSection | No errors. |
| Moka\Cms\GeneratedEntity\Menu\MainProductSection | No errors. |
| Moka\Cms\GeneratedEntity\Menu\MainLink | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Contact | No errors. |
| Moka\Cms\GeneratedEntity\Entry\ContactTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\News | No errors. |
| Moka\Cms\GeneratedEntity\Entry\NewsTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Thematic | No errors. |
| Moka\Cms\GeneratedEntity\Entry\ThematicTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\NewsList | No errors. |
| Moka\Cms\GeneratedEntity\Entry\NewsListTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Menu\Footer | No errors. |
| Moka\Cms\GeneratedEntity\Menu\FooterColumn | No errors. |
| Moka\Cms\GeneratedEntity\Menu\FooterLink | No errors. |
| Moka\Cms\GeneratedEntity\Menu\LastFooter | No errors. |
| Moka\Cms\GeneratedEntity\Menu\LastFooterLink | No errors. |