Query Metrics
70
Database Queries
4
Different statements
40.82 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
18.83 ms (46.14%) |
18 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.name AS name_3, t0.description AS description_4, t0.usual_quantity AS usual_quantity_5, t0.buying_price_ht AS buying_price_ht_6, t0.buying_price_ttc AS buying_price_ttc_7, t0.price_ht AS price_ht_8, t0.price_ttc AS price_ttc_9, t0.unit AS unit_10, t0.is_stock AS is_stock_11, t0.is_declination AS is_declination_12, t0.created_at AS created_at_13, t0.uuid AS uuid_14, t0.information AS information_15, t0.is_archived AS is_archived_16, t0.deleted_at AS deleted_at_17, t0.reason_of_delete AS reason_of_delete_18, t0.best_selection AS best_selection_19, t0.material AS material_20, t0.supplier_reference AS supplier_reference_21, t0.meta_description AS meta_description_22, t0.show_in_web_site AS show_in_web_site_23, t0.buy_tva_id AS buy_tva_id_24, t0.categories_id AS categories_id_25, t0.tva_id AS tva_id_26, t0.promotion_id AS promotion_id_27, t0.supplier_id AS supplier_id_28 FROM produit t0 WHERE t0.categories_id = ?
Parameters:
[
93
]
|
|
10.50 ms (25.72%) |
25 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id = ? ORDER BY t0.`order` ASC
Parameters:
[
93
]
|
|
9.40 ms (23.02%) |
23 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.footer_logo AS footer_logo_4, t0.address AS address_5, t0.region AS region_6, t0.tva AS tva_7, t0.mail AS mail_8, t0.website AS website_9, t0.phone AS phone_10, t0.mobile AS mobile_11, t0.title AS title_12, t0.description AS description_13, t0.keywords AS keywords_14, t0.social_links AS social_links_15, t0.updated_at AS updated_at_16 FROM company t0 LIMIT 1
Parameters:
[] |
|
2.10 ms (5.13%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.`order` AS order_4, t0.`homepage_order` AS homepage_order_5, t0.show_in_homepage AS show_in_homepage_6, t0.show_in_menu AS show_in_menu_7, t0.is_active AS is_active_8, t0.parent_id AS parent_id_9 FROM category t0 WHERE t0.parent_id IS NULL AND t0.is_active = ? ORDER BY t0.`order` ASC
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Company | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Produit |
|
| App\Entity\Tva | No errors. |
| App\Entity\Promotion | No errors. |
| App\Entity\Supplier | No errors. |
| App\Entity\Tag | No errors. |
| App\Entity\Declination | No errors. |
| App\Entity\ProduitDeclinationValue | No errors. |
| App\Entity\File | No errors. |
| App\Entity\DocumentProduit | No errors. |
| App\Entity\Stock | No errors. |
| App\Entity\Activity | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ProduitPromotionHistory | No errors. |