Query Metrics
16
Database Queries
12
Different statements
32,19 ms
Query time
0
Invalid entities
156
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
6,79 ms (21,11%) |
2 |
SELECT t0.id AS id_1, t0.tag AS tag_2, t0.name AS name_3, t0.class AS class_4, t0.has_parent_link AS has_parent_link_5, t0.has_leveling AS has_leveling_6, t0.has_ssmenu AS has_ssmenu_7, t0.config AS config_8, t0.is_in_sitemap AS is_in_sitemap_9, t0.ref_language_id AS ref_language_id_10 FROM menu t0 WHERE t0.tag = ? LIMIT 1
Parameters:
[
"menu_haut"
]
|
|
5,79 ms (17,98%) |
3 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.address_comp AS address_comp_4, t0.zip_code AS zip_code_5, t0.town AS town_6, t0.country AS country_7, t0.coordinates AS coordinates_8, t0.phone AS phone_9, t0.phone2 AS phone2_10, t0.fax AS fax_11, t0.is_active AS is_active_12 FROM config_client_address t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
|
5,41 ms (16,81%) |
1 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.rewrite AS rewrite_3, n0_.is_active AS is_active_4 FROM news_type n0_ WHERE n0_.rewrite = ? ORDER BY n0_.name ASC
Parameters:
[
"groupe-1"
]
|
|
3,92 ms (12,17%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.ref_language_id AS ref_language_id_4 FROM config_translation t0
Parameters:
[] |
|
3,25 ms (10,09%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.tinymce_classes AS tinymce_classes_3, t0.analytics AS analytics_4, t0.password AS password_5, t0.captcha_key AS captcha_key_6, t0.captcha_key_secret AS captcha_key_secret_7, t0.is_active AS is_active_8, t0.ips_auth AS ips_auth_9, t0.js_additional AS js_additional_10, t0.rgpd_catchphrase AS rgpd_catchphrase_11, t0.rgpd_content AS rgpd_content_12 FROM config_site t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
3,07 ms (9,55%) |
1 |
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.favicon AS favicon_3, t0.email AS email_4, t0.name AS name_5, t0.seo_baseline AS seo_baseline_6, t0.social_linked_in AS social_linked_in_7, t0.social_facebook AS social_facebook_8, t0.social_twitter AS social_twitter_9, t0.social_youtube AS social_youtube_10, t0.social_instagram AS social_instagram_11, t0.social_snapchat AS social_snapchat_12, t0.social_tik_tok AS social_tik_tok_13, t0.maintenance_background AS maintenance_background_14, t0.maintenance_color AS maintenance_color_15, t0.maintenance_content AS maintenance_content_16 FROM config_client t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
2,20 ms (6,84%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.content_small AS content_small_2, p0_.content AS content_3, p0_.image AS image_4, p0_.rank_order AS rank_order_5, p0_.is_active AS is_active_6, p0_.meta_title AS meta_title_7, p0_.meta_content AS meta_content_8, p0_.meta_og_title AS meta_og_title_9, p0_.meta_og_image AS meta_og_image_10, p0_.meta_twitter_title AS meta_twitter_title_11, p0_.meta_twitter_image AS meta_twitter_image_12, p0_.rewrite AS rewrite_13, p0_.date_update AS date_update_14, p0_.ref_language_id AS ref_language_id_15, p0_.ref_page_id AS ref_page_id_16 FROM page p0_ WHERE p0_.is_active = 1 AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 4 9 5 6 7 10 11 8 ] |
|
0,62 ms (1,93%) |
2 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.is_target_blank AS is_target_blank_3, n0_.link_type AS link_type_4, n0_.image AS image_5, n0_.custom AS custom_6, n0_.link AS link_7, n0_.ref_menu_id AS ref_menu_id_8, n0_.ref_navigation_id AS ref_navigation_id_9 FROM navigation n0_ WHERE n0_.ref_menu_id = ? ORDER BY n0_.rank_order ASC
Parameters:
[
1
]
|
|
0,33 ms (1,02%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_key AS name_key_2, c0_.image AS image_3, c0_.content AS content_4, c0_.content_small AS content_small_5, c0_.meta_title AS meta_title_6, c0_.meta_content AS meta_content_7, c0_.meta_og_title AS meta_og_title_8, c0_.meta_og_image AS meta_og_image_9, c0_.meta_twitter_title AS meta_twitter_title_10, c0_.meta_twitter_image AS meta_twitter_image_11, c0_.is_active AS is_active_12 FROM config_resource c0_ WHERE c0_.name_key = ? AND c0_.is_active = ? LIMIT 1
Parameters:
[ "actualites" 1 ] |
|
0,28 ms (0,87%) |
1 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.content_small AS content_small_2, p0_.content AS content_3, p0_.image AS image_4, p0_.rank_order AS rank_order_5, p0_.is_active AS is_active_6, p0_.meta_title AS meta_title_7, p0_.meta_content AS meta_content_8, p0_.meta_og_title AS meta_og_title_9, p0_.meta_og_image AS meta_og_image_10, p0_.meta_twitter_title AS meta_twitter_title_11, p0_.meta_twitter_image AS meta_twitter_image_12, p0_.rewrite AS rewrite_13, p0_.date_update AS date_update_14, p0_.ref_language_id AS ref_language_id_15, p0_.ref_page_id AS ref_page_id_16 FROM page p0_ WHERE p0_.is_active = 1 AND p0_.id IN (?, ?)
Parameters:
[ 2 3 ] |
|
0,28 ms (0,86%) |
1 |
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.rank_order AS rank_order_2, n0_.rewrite AS rewrite_3, n0_.is_active AS is_active_4 FROM news_type n0_ WHERE (SELECT COUNT(*) FROM news n1_ WHERE n1_.ref_news_type_id = n0_.id) > 0 AND n0_.is_active = 1 ORDER BY n0_.name ASC
Parameters:
[] |
|
0,25 ms (0,78%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.commentary AS commentary_4, t0.is_active AS is_active_5 FROM config_constant t0 WHERE t0.is_active = ?
Parameters:
[
1
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Config\Translation | 115 |
| App\Modules\Menu\Entity\Navigation | 13 |
| App\Modules\Page\Entity\Page | 11 |
| App\Entity\Config\Constant | 8 |
| App\Entity\Config\Language | 2 |
| App\Modules\Menu\Entity\Menu | 2 |
| App\Modules\News\Entity\NewsType | 2 |
| App\Entity\Config\Site | 1 |
| App\Entity\Config\Client | 1 |
| App\Entity\Config\ClientAddress | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Config\Site | No errors. |
| App\Entity\Config\Client | No errors. |
| App\Entity\Config\ClientAddress | No errors. |
| App\Entity\Config\Constant | No errors. |
| App\Entity\Config\Translation | No errors. |
| App\Entity\Config\Language | No errors. |
| App\Modules\Menu\Entity\Menu | No errors. |
| App\Modules\Menu\Entity\Navigation | No errors. |
| App\Modules\Page\Entity\Page | No errors. |
| App\Modules\News\Entity\NewsType | No errors. |
| App\Modules\News\Entity\News | No errors. |
| App\Entity\Config\Resource | No errors. |