Query Metrics
202
Database Queries
25
Different statements
114.68 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
17.30 ms (15.08%) |
7 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"LV_Order"
]
|
14.61 ms (12.74%) |
5 |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "get-list" "path" => "/api-v1/order/" ] |
10.82 ms (9.43%) |
36 |
Select text FROM translations_admin WHERE translations_admin.key = "active" AND translations_admin.language = "fr"
Parameters:
[] |
8.05 ms (7.02%) |
1 |
Select text FROM translations_admin WHERE translations_admin.key = "twistInProcess" AND translations_admin.language = "fr"
Parameters:
[] |
7.51 ms (6.55%) |
1 |
SELECT object_LV_Order.o_id as o_id, `object_LV_Order`.`o_type`, `sku`.`sku`, `sku`.`marketing__id`, `marketing`.`name`, `patternRange`.`o_key`, `patternRange`.`o_id`, `printer`.`site__id`, `printer`.`name`, `site`.`name`, `productPanel`.`label`, `translations_admin_source`.`text` AS `source_label`, `translations_admin_status`.`text` AS `status_label` FROM `object_LV_Order` LEFT JOIN `object_LV_Sku` AS `sku` ON sku.oo_id = object_LV_Order.sku__id LEFT JOIN `object_LV_Marketing` AS `marketing` ON sku.marketing__id = marketing.oo_id LEFT JOIN `objects` AS `patternRange` ON sku.patternRange__id = patternRange.o_id LEFT JOIN `object_LV_Printer` AS `printer` ON printer.oo_id = object_LV_Order.printer__id LEFT JOIN `object_LV_Site` AS `site` ON printer.site__id = site.oo_id LEFT JOIN `object_LV_ProductPanel` AS `productPanel` ON productPanel.oo_id = object_LV_Order.productPanel__id LEFT JOIN `translations_admin` AS `translations_admin_source` ON translations_admin_source.language="fr" AND translations_admin_source.key = object_LV_Order.source LEFT JOIN `translations_admin` AS `translations_admin_status` ON translations_admin_status.language="fr" AND translations_admin_status.key = object_LV_Order.status WHERE (( object_LV_Order.o_type IN ('object','folder')) AND object_LV_Order.o_published = 1) GROUP BY `object_LV_Order`.`oo_id` ORDER BY status_label DESC LIMIT 20
Parameters:
[] |
7.25 ms (6.32%) |
22 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_863__960f19cc72cd30d55a43cf66217493a8"
]
|
5.60 ms (4.88%) |
16 |
Select text FROM translations_admin WHERE translations_admin.key = "test" AND translations_admin.language = "fr"
Parameters:
[] |
4.45 ms (3.88%) |
8 |
Select text FROM translations_admin WHERE translations_admin.key = "null" AND translations_admin.language = "fr"
Parameters:
[] |
3.99 ms (3.48%) |
12 |
Select text FROM translations_admin WHERE translations_admin.key = "Manuelle" AND translations_admin.language = "fr"
Parameters:
[] |
3.92 ms (3.42%) |
4 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/api-v1/order/get-list" ] |
3.88 ms (3.38%) |
12 |
Select text FROM translations_admin WHERE translations_admin.key = "French" AND translations_admin.language = "fr"
Parameters:
[] |
3.65 ms (3.18%) |
12 |
Select text FROM translations_admin WHERE translations_admin.key = "Administrateur" AND translations_admin.language = "fr"
Parameters:
[] |
3.31 ms (2.88%) |
12 |
SELECT `text` FROM translations_website WHERE translations_website.language = "fr" AND translations_website.key = ""
Parameters:
[] |
3.26 ms (2.84%) |
8 |
SELECT * FROM locks WHERE id = ?
Parameters:
[
"document-thumbnail-241-1"
]
|
2.52 ms (2.19%) |
8 |
Select text FROM translations_admin WHERE translations_admin.key = "Small" AND translations_admin.language = "fr"
Parameters:
[] |
2.44 ms (2.13%) |
8 |
Select text FROM translations_admin WHERE translations_admin.key = "Diagonal" AND translations_admin.language = "fr"
Parameters:
[] |
2.25 ms (1.96%) |
1 |
SELECT object_LV_Order.o_id as o_id, `object_LV_Order`.`o_type`, `sku`.`sku`, `sku`.`marketing__id`, `marketing`.`name`, `patternRange`.`o_key`, `patternRange`.`o_id`, `printer`.`site__id`, `printer`.`name`, `site`.`name`, `productPanel`.`label`, `translations_admin_source`.`text` AS `source_label`, `translations_admin_status`.`text` AS `status_label` FROM `object_LV_Order` LEFT JOIN `object_LV_Sku` AS `sku` ON sku.oo_id = object_LV_Order.sku__id LEFT JOIN `object_LV_Marketing` AS `marketing` ON sku.marketing__id = marketing.oo_id LEFT JOIN `objects` AS `patternRange` ON sku.patternRange__id = patternRange.o_id LEFT JOIN `object_LV_Printer` AS `printer` ON printer.oo_id = object_LV_Order.printer__id LEFT JOIN `object_LV_Site` AS `site` ON printer.site__id = site.oo_id LEFT JOIN `object_LV_ProductPanel` AS `productPanel` ON productPanel.oo_id = object_LV_Order.productPanel__id LEFT JOIN `translations_admin` AS `translations_admin_source` ON translations_admin_source.language="fr" AND translations_admin_source.key = object_LV_Order.source LEFT JOIN `translations_admin` AS `translations_admin_status` ON translations_admin_status.language="fr" AND translations_admin_status.key = object_LV_Order.status WHERE (( object_LV_Order.o_type IN ('object','folder')) AND object_LV_Order.o_published = 1) GROUP BY `object_LV_Order`.`oo_id`
Parameters:
[] |
2.22 ms (1.94%) |
8 |
Select text FROM translations_admin WHERE translations_admin.key = "Centre-Centre" AND translations_admin.language = "fr"
Parameters:
[] |
1.90 ms (1.65%) |
6 |
Select text FROM translations_admin WHERE translations_admin.key = "printReady" AND translations_admin.language = "fr"
Parameters:
[] |
1.84 ms (1.61%) |
4 |
Select text FROM translations_admin WHERE translations_admin.key = "notCustomizable" AND translations_admin.language = "fr"
Parameters:
[] |
1.25 ms (1.09%) |
4 |
Select text FROM translations_admin WHERE translations_admin.key = "customizable" AND translations_admin.language = "fr"
Parameters:
[] |
1.12 ms (0.98%) |
4 |
Select text FROM translations_admin WHERE translations_admin.key = "donePrinting" AND translations_admin.language = "fr"
Parameters:
[] |
0.79 ms (0.69%) |
1 |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/api-v1/order/get-list/" "sourcePathQuery" => "/api-v1/order/get-list/?filter={}&limit=20&offset=0&order=desc&orderKey=status&user_id=179" "sourceEntireUri" => "https://backoffice.vuitton.galilee.fr/api-v1/order/get-list/?filter={}&limit=20&offset=0&order=desc&orderKey=status&user_id=179" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
0.46 ms (0.40%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
0.31 ms (0.27%) |
1 |
Select text FROM translations_admin WHERE translations_admin.key = "failedPrintingProcess" AND translations_admin.language = "fr"
Parameters:
[] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.