Query Metrics
65
Database Queries
16
Different statements
37.51 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.92 ms (37.11%) |
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
]
|
|
6.34 ms (16.90%) |
14 |
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
]
|
|
2.78 ms (7.41%) |
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
]
|
|
2.28 ms (6.09%) |
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"
]
|
|
1.69 ms (4.50%) |
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.36 ms (3.62%) |
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.36 ms (3.61%) |
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.35 ms (3.59%) |
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, m1_.parent_page AS parent_page_9 FROM moka_entry_page m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id LEFT JOIN moka_entry_page_translation m2_ ON m1_.id = m2_.translatable_id WHERE m0_.mode = ? AND m2_.locale = ? AND m2_.slug = ?
Parameters:
[ "main" "fr_FR" "concept" ] |
|
1.28 ms (3.41%) |
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.19 ms (3.18%) |
2 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.summary AS summary_3, t0.body AS body_4, t0.slug AS slug_5, t0.seo AS seo_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.locale AS locale_9, t0.image_header AS image_header_10, t0.translatable_id AS translatable_id_11 FROM moka_entry_page_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
40
]
|
|
0.80 ms (2.14%) |
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.74 ms (1.96%) |
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.64 ms (1.71%) |
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
]
|
|
0.63 ms (1.68%) |
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.58 ms (1.53%) |
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.parent_page AS parent_page_10, t1._entry_type FROM moka_entry_page t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
38
]
|
|
0.57 ms (1.53%) |
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:
[] |
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\Page | No errors. |
| Moka\Cms\GeneratedEntity\Entry\PageTranslation | 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\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\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. |