Query Metrics
5
Database Queries
5
Different statements
4.66 ms
Query time
0
Invalid entities
Queries
default connection
#▲ | Time | Info |
---|---|---|
1 | 0.85 ms |
SELECT t0.id_lang AS id_lang_1, t0.name AS name_2, t0.active AS active_3, t0.iso_code AS iso_code_4, t0.language_code AS language_code_5, t0.date_format_lite AS date_format_lite_6, t0.date_format_full AS date_format_full_7, t0.dictionary AS dictionary_8, t0.currency_format AS currency_format_9, t0.iso_code_real AS iso_code_real_10, t0.name_english AS name_english_11 FROM ps_lang t0 WHERE t0.iso_code = ? LIMIT 1
Parameters:
[
"fr"
]
|
2 | 0.58 ms |
SELECT DATABASE()
Parameters:
[] |
3 | 1.45 ms |
SELECT p0_.id AS id_0, p0_.meta_title AS meta_title_1, p0_.meta_description AS meta_description_2, p0_.name AS name_3, p0_.meta_keywords AS meta_keywords_4, p0_.content AS content_5, p0_.link_rewrite AS link_rewrite_6, p0_.redirect AS redirect_7, p0_.id_cms AS id_cms_8, p0_.id_lang AS id_lang_9 FROM ps_cms_lang p0_ INNER JOIN ps_cms p1_ ON p0_.id_cms = p1_.id_cms WHERE p0_.link_rewrite = ? AND p0_.id_lang = ?
Parameters:
[ "confitures-miel-et-pates-a-tartiner-pate-a-tartiner-au-chocolat.html" 5 ] |
4 | 0.69 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.link_rewrite AS link_rewrite_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.meta_keywords AS meta_keywords_6, t0.id_taxonomy AS id_taxonomy_7, t0.id_lang AS id_lang_8 FROM taxonomy_lang t0 WHERE t0.id_taxonomy = ? AND t0.id_lang = ? LIMIT 1
Parameters:
[ 12289 5 ] |
legacy connection
#▲ | Time | Info |
---|---|---|
1 | 1.10 ms |
SELECT * FROM `ps_lang` WHERE iso_code = :iso_code AND active = 1
Parameters:
[ ":iso_code" => "fr" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
report | doctrine.dbal.report_connection |
logs | doctrine.dbal.logs_connection |
Entity Managers
Name | Service |
---|---|
auto_generate_proxy_classes | doctrine.orm.auto_generate_proxy_classes_entity_manager |
default | doctrine.orm.default_entity_manager |
report | doctrine.orm.report_entity_manager |
logs | doctrine.orm.logs_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
auto_generate_proxy_classes entity manager
No loaded entities.
default entity manager
report entity manager
Class | Mapping errors |
---|---|
App\Entity\Report\CustomerAuthenticationAccessControl | No errors. |
App\Entity\Report\CustomerAuthenticationAccessControlLog | No errors. |
App\Entity\Report\CustomerStats | No errors. |
logs entity manager
No loaded entities.