Query Metrics
4
Database Queries
3
Different statements
10.10 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2.38 ms |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3 FROM faq t0
Parameters:
[]
|
||||||||||||||||||||||||||||
2 | 0.38 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.protection_alias AS protection_alias_3, p0_.protection_full_name AS protection_full_name_4, p1_.id AS id_5, p1_.name AS name_6, p1_.description AS description_7, p1_.slug AS slug_8, p2_.id AS id_9, p2_.name AS name_10, p2_.description AS description_11, p2_.max_file_size AS max_file_size_12, p2_.slug AS slug_13, p0_.icon_id AS icon_id_14, p1_.category_id AS category_id_15, p1_.protection_category_id AS protection_category_id_16, p2_.instance_id AS instance_id_17 FROM protection_category p0_ INNER JOIN product_instance p1_ ON p0_.id = p1_.protection_category_id INNER JOIN product_type p2_ ON p1_.id = p2_.instance_id INNER JOIN product_price p3_ ON p2_.id = p3_.product_type_id
Parameters:
[]
|
||||||||||||||||||||||||||||
3 | 3.75 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.action AS action_3, t0.product_type_id AS product_type_id_4, t0.type_id AS type_id_5 FROM product_price t0 WHERE t0.product_type_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
4 | 3.59 ms |
SELECT t0.id AS id_1, t0.value AS value_2, t0.action AS action_3, t0.product_type_id AS product_type_id_4, t0.type_id AS type_id_5 FROM product_price t0 WHERE t0.product_type_id = ?
Parameters:
[
2
]
|
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\Base\AEntity | No errors. |
App\Entity\Statics\FAQ | No errors. |
App\Entity\Base\TData | No errors. |
App\Entity\Product\ProtectionCategory | No errors. |
App\Entity\Product\Instance |
|
App\Entity\Product\Type |
|
App\Entity\Product\Price | No errors. |
Sonata\MediaBundle\Entity\BaseMedia | No errors. |
App\Entity\Media\Media |
|
App\Entity\Product\Category |
|
App\Entity\Product\Additionals\Positive | No errors. |
App\Entity\Transactions\Transaction | No errors. |
App\Entity\Product\PriceType | No errors. |