Query Metrics
26
Database Queries
14
Different statements
23.98 ms
Query time
1
Invalid entities
1
Managed entities
Queries
pim connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.18 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 12 OFFSET 60
Parameters:
[
"fraises"
]
|
| 2 | 0.59 ms |
SELECT * FROM product_image WHERE product_id IN (?,?,?,?,?,?) ORDER BY is_primary DESC, sort_order ASC
Parameters:
[ 3 4 6 5 1 2 ] |
| 3 | 0.55 ms |
SELECT COUNT(*) FROM product p LEFT JOIN universe u ON p.universe_id = u.id WHERE p.is_active = true AND u.slug = ?
Parameters:
[
"fraises"
]
|
| 4 | 0.26 ms |
SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC
Parameters:
[] |
| 5 | 0.67 ms |
SELECT c.*, u.name as universe_name, u.slug as universe_slug, p.name as parent_name FROM category c LEFT JOIN universe u ON c.universe_id = u.id LEFT JOIN category p ON c.parent_id = p.id WHERE c.is_active = true ORDER BY c.sort_order ASC, c.name ASC
Parameters:
[] |
| 6 | 0.71 ms |
SELECT uc.* FROM universe_characteristic uc JOIN universe u ON uc.universe_id = u.id WHERE u.slug = ? ORDER BY uc.sort_order ASC
Parameters:
[
"fraises"
]
|
| 7 | 1.54 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 8 | 1.44 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 9 | 1.34 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 10 | 1.37 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 11 | 1.31 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 12 | 1.34 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 13 | 1.29 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 14 | 1.36 ms |
SELECT p.*, u.name as universe_name, u.slug as universe_slug, m.name as manufacturer_name, m.code as manufacturer_code FROM product p LEFT JOIN universe u ON p.universe_id = u.id LEFT JOIN manufacturer m ON p.manufacturer_id = m.id WHERE p.is_active = true AND u.slug = ? ORDER BY p.label ASC LIMIT 1000 OFFSET 0
Parameters:
[
"fraises"
]
|
| 15 | 0.25 ms |
SELECT u.* FROM universe u WHERE u.slug = ?
Parameters:
[
"fraises"
]
|
| 16 | 0.24 ms |
SELECT u.* FROM universe u WHERE u.slug = ?
Parameters:
[
"fraises"
]
|
| 17 | 0.25 ms |
SELECT u.* FROM universe u WHERE u.slug = ?
Parameters:
[
"fraises"
]
|
| 18 | 0.27 ms |
SELECT u.* FROM universe u WHERE u.is_active = true ORDER BY u.sort_order ASC, u.name ASC
Parameters:
[] |
default connection
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| pim | doctrine.dbal.pim_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\Cart | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Cart | No errors. |
| App\Entity\User |
|
| App\Entity\CartItem | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Universe | No errors. |