https://www.preprod.solidpool.com/fr/magasin/6521-tarbes

Query Metrics

62 Database Queries
17 Different statements
37.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.16 ms
(42.67%)
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.00 ms
(15.85%)
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.51 ms
(6.61%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_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.translatable_id AS translatable_id_10 FROM moka_entry_store_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  62
]
1.98 ms
(5.24%)
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 LEFT JOIN moka_entry_store_translation m2_ ON m1_.id = m2_.translatable_id WHERE m0_.mode = ? AND m2_.locale = ? AND m2_.slug = ?
Parameters:
[
  "main"
  "fr_FR"
  "6521-tarbes"
]
1.98 ms
(5.22%)
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
]
1.51 ms
(4.00%)
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.16 ms
(3.06%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.advertising_title AS advertising_title_3, t0.advertising_summary AS advertising_summary_4, t0.advertising_button_link AS advertising_button_link_5, t0.advertising_button_text AS advertising_button_text_6, t0.seo AS seo_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.locale AS locale_10, t0.translatable_id AS translatable_id_11 FROM moka_entry_store_locator_translation t0 WHERE t0.translatable_id = ?
Parameters:
[
  6
]
0.97 ms
(2.55%)
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"
]
0.91 ms
(2.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_.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"
]
0.86 ms
(2.28%)
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"
]
0.82 ms
(2.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, t0.advertising_image AS advertising_image_10, t1._entry_type FROM moka_entry_store_locator t0 INNER JOIN moka_entry t1 ON t0.id = t1.id WHERE t1.mode = ? AND t1.status = ? LIMIT 1
Parameters:
[
  "main"
  "published"
]
0.82 ms
(2.15%)
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"
]
0.57 ms
(1.52%)
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.43 ms
(1.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.41 ms
(1.07%)
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.39 ms
(1.04%)
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.38 ms
(1.01%)
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\Store No errors.
Moka\Cms\GeneratedEntity\Entry\StoreTranslation 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\Entry\StoreLocator No errors.
Moka\Cms\GeneratedEntity\Entry\StoreLocatorTranslation 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.