Query Metrics
82
Database Queries
23
Different statements
56.35 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.20 ms (23.43%) |
26 |
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:
[
72
]
|
|
7.23 ms (12.83%) |
16 |
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:
[
10
]
|
|
5.91 ms (10.48%) |
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:
[
1
]
|
|
4.64 ms (8.24%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.slug AS slug_4, t0.seo AS seo_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.locale AS locale_8, t0.icon AS icon_9, t0.translatable_id AS translatable_id_10 FROM moka_entry_thematic_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
16
]
|
|
3.85 ms (6.83%) |
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:
[
"fr_FR"
]
|
|
3.59 ms (6.37%) |
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, m0_._entry_type AS _entry_type_7, m0_.parent_id AS parent_id_8 FROM moka_entry_news_list m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id LEFT JOIN moka_entry_news_list_translation m2_ ON m1_.id = m2_.translatable_id WHERE m0_.mode = ? AND m2_.locale = ?
Parameters:
[ "main" "fr_FR" ] |
|
2.40 ms (4.26%) |
4 |
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:
[
106
]
|
|
1.58 ms (2.81%) |
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.54 ms (2.73%) |
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:
[
"fr_FR"
]
|
|
1.38 ms (2.45%) |
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:
[
"fr_FR"
]
|
|
1.36 ms (2.41%) |
1 |
SELECT count(m0_.id) AS sclr_0 FROM moka_entry_news m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.status = ? AND m0_.locales LIKE ?
Parameters:
[ "published" "%fr_FR%" ] |
|
1.23 ms (2.18%) |
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:
[
"fr_FR"
]
|
|
1.21 ms (2.14%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.seo AS seo_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM moka_entry_news_list_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
8
]
|
|
1.02 ms (1.81%) |
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.96 ms (1.71%) |
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.85 ms (1.50%) |
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, m0_._entry_type AS _entry_type_7, m0_.parent_id AS parent_id_8 FROM moka_entry_thematic m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.locales LIKE ?
Parameters:
[
"%fr_FR%"
]
|
|
0.74 ms (1.31%) |
1 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_4 FROM (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_.published_at AS published_at_7, m1_.tutorial AS tutorial_8, m0_._entry_type AS _entry_type_9 FROM moka_entry_news m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.mode = ? AND m0_.status = ? AND m0_.locales LIKE ? ORDER BY m0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[ "main" "published" "%fr_FR%" ] |
|
0.69 ms (1.22%) |
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.66 ms (1.18%) |
1 |
SELECT DISTINCT id_4 FROM (SELECT DISTINCT id_4, created_at_5 FROM (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_.published_at AS published_at_7, m1_.tutorial AS tutorial_8, m0_._entry_type AS _entry_type_9 FROM moka_entry_news m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.mode = ? AND m0_.status = ? AND m0_.locales LIKE ?) dctrn_result_inner ORDER BY created_at_5 DESC) dctrn_result LIMIT 9
Parameters:
[ "main" "published" "%fr_FR%" ] |
|
0.61 ms (1.08%) |
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_.published_at AS published_at_7, m1_.tutorial AS tutorial_8, m0_._entry_type AS _entry_type_9, m0_.parent_id AS parent_id_10, m1_.image_header AS image_header_11 FROM moka_entry_news m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.mode = ? AND m0_.status = ? AND m0_.locales LIKE ? AND m0_.id IN (?, ?, ?, ?) ORDER BY m0_.created_at DESC
Parameters:
[ "main" "published" "%fr_FR%" 106 90 15 7 ] |
|
0.57 ms (1.01%) |
1 |
SELECT count(m0_.id) AS sclr_0 FROM moka_entry_news m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.status = ? AND m0_.locales LIKE ? AND m1_.tutorial = 1
Parameters:
[ "published" "%fr_FR%" ] |
|
0.57 ms (1.00%) |
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.56 ms (0.98%) |
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\NewsList | No errors. |
| Moka\Cms\GeneratedEntity\Entry\NewsListTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Thematic | No errors. |
| Moka\Cms\GeneratedEntity\Entry\ThematicTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\News | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Affiliate | No errors. |
| Moka\Cms\GeneratedEntity\Media\Media | 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\Entry\Homepage | No errors. |
| Moka\Cms\GeneratedEntity\Entry\HomepageTranslation | 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\NewsTranslation | 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. |