Query Metrics
60
Database Queries
15
Different statements
72.54 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
50.19 ms (69.18%) |
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
]
|
|
5.59 ms (7.71%) |
11 |
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.87 ms (3.95%) |
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.83 ms (3.91%) |
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_.address AS address_7, m1_.latitude AS latitude_8, m1_.longitude AS longitude_9, m1_.phone AS phone_10, m1_.email AS email_11, m1_.code AS code_12, m1_.opening_hours_monday AS opening_hours_monday_13, m1_.opening_hours_tuesday AS opening_hours_tuesday_14, m1_.opening_hours_wednesday AS opening_hours_wednesday_15, m1_.opening_hours_thursday AS opening_hours_thursday_16, m1_.opening_hours_friday AS opening_hours_friday_17, m1_.opening_hours_saturday AS opening_hours_saturday_18, m1_.opening_hours_sunday AS opening_hours_sunday_19, m0_._entry_type AS _entry_type_20, m0_.parent_id AS parent_id_21, m1_.image_header AS image_header_22 FROM moka_entry_store m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id WHERE m0_.status = ? AND m0_.mode = ?
Parameters:
[ "published" "main" ] |
|
1.93 ms (2.66%) |
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.32 ms (1.81%) |
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.31 ms (1.80%) |
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.30 ms (1.79%) |
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.17 ms (1.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 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.16 ms (1.60%) |
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_contact m1_ INNER JOIN moka_entry m0_ ON m1_.id = m0_.id LEFT JOIN moka_entry_contact_translation m2_ ON m1_.id = m2_.translatable_id WHERE m0_.mode = ? AND m2_.locale = ?
Parameters:
[ "main" "fr_FR" ] |
|
0.71 ms (0.97%) |
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.61 ms (0.84%) |
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.56 ms (0.77%) |
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.54 ms (0.75%) |
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.46 ms (0.64%) |
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\Contact | No errors. |
| Moka\Cms\GeneratedEntity\Entry\ContactTranslation | No errors. |
| Moka\Cms\GeneratedEntity\Entry\Store | No errors. |
| Moka\Cms\GeneratedEntity\Media\Media | No errors. |
| Moka\Cms\GeneratedEntity\Entry\StoreTranslation | 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\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. |