Query Metrics
10
Database Queries
9
Different statements
8.35 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.68 ms (20.07%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"fr"
]
|
1.47 ms (17.65%) |
1 |
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.is_enable AS is_enable_2, p0_.is_contact AS is_contact_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.description AS description_6, p0_.classe_titre_contact AS classe_titre_contact_7, p0_.link_visiter_site AS link_visiter_site_8, p0_.classe_body_page AS classe_body_page_9, p0_.is_demo AS is_demo_10 FROM page p0_ LEFT JOIN page_lang p1_ ON p0_.id = p1_.page_id AND (p1_.language_id = ?) WHERE (p0_.deleted_at IS NULL AND p0_.is_enable = 1) AND p0_.id IN (?, ?, ?, ?) ORDER BY p0_.id ASC
Parameters:
[ 1 "10" "8" "5" "4" ] |
1.04 ms (12.45%) |
1 |
SELECT t0.id AS id_1, t0.route AS route_2, t0.parameter AS parameter_3 FROM seo t0 WHERE t0.route = ? AND t0.parameter IS NULL LIMIT 1
Parameters:
[
"contact_message"
]
|
0.99 ms (11.88%) |
1 |
SELECT p0_.slug AS slug_0, p1_.id AS id_1, p0_.name AS name_2 FROM page_lang p0_ INNER JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = ? AND p1_.parent_id = ?
Parameters:
[ 1 "10" ] |
0.90 ms (10.82%) |
1 |
SELECT p0_.slug AS slug_0, p0_.page_category_id AS sclr_1 FROM page_category_lang p0_ WHERE p0_.language_id = ? AND p0_.page_category_id IN (?)
Parameters:
[ 1 "1" ] |
0.79 ms (9.44%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.language_id AS language_id_5, t0.seo_id AS seo_id_6 FROM seo_lang t0 WHERE t0.seo_id IS NULL AND t0.language_id = ? LIMIT 1
Parameters:
[
1
]
|
0.57 ms (6.81%) |
1 |
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 "4" "5" "8" "10" "9" "21" "32" "43" ] |
0.54 ms (6.50%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.is_actif AS is_actif_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8 FROM languages t0 WHERE t0.deleted_at IS NULL AND t0.is_actif = ?
Parameters:
[
1
]
|
0.37 ms (4.37%) |
1 |
SELECT p0_.slug AS slug_0, p0_.page_id AS sclr_1 FROM page_lang p0_ WHERE p0_.language_id = ? AND p0_.page_id IN (?, ?)
Parameters:
[ 1 "21" "22" ] |
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 |
---|---|
App\Entity\Languages | No errors. |
App\Entity\ClientBlocs\ClientBlocLang | No errors. |
App\Entity\Labels\LabelBlocLang | No errors. |
App\Entity\Labels\LabelSliderLang | No errors. |
App\Entity\ItemsSolution\ItemsSolutionLang | No errors. |
App\Entity\Benefice\BeneficeLang | No errors. |
App\Entity\Benefice\BeneficeItemsLang | No errors. |
App\Entity\Pages\PageSousCategoryLang | No errors. |
App\Entity\User\UserStatusLang | No errors. |
App\Entity\Pages\PageCategoryLang | No errors. |
App\Entity\Pages\PageCategory | No errors. |
App\Entity\Pages\PageLang | No errors. |
App\Entity\Pages\Page | No errors. |
App\Entity\Seo\Seo | No errors. |
App\Entity\Seo\SeoLang | No errors. |