Query Metrics
604
Database Queries
77
Different statements
1004.99 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
476.91 ms (47.45%) |
403 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1786535203 [ "\x00tags\x00site_domain_89772068f835601767b94b4411dfead7" "site_domain_89772068f835601767b94b4411dfead7" ] ] |
|
91.47 ms (9.10%) |
6 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'productCategory' AND `documents_page`.`controller` = 'App\\Controller\\ProductCategoryController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:100000094;%' AND `documents`.`published` = 1
Parameters:
[] |
|
86.79 ms (8.64%) |
6 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'productCategory' AND `documents_page`.`controller` = 'App\\Controller\\ProductCategoryController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:100000166;%' AND `documents`.`published` = 1
Parameters:
[] |
|
52.71 ms (5.25%) |
4 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'productCategory' AND `documents_page`.`controller` = 'App\\Controller\\ProductCategoryController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:100000208;%' AND `documents`.`published` = 1
Parameters:
[] |
|
37.17 ms (3.70%) |
2 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'productCategory' AND `documents_page`.`controller` = 'App\\Controller\\ProductCategoryController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:100000253;%' AND `documents`.`published` = 1
Parameters:
[] |
|
23.41 ms (2.33%) |
11 |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "hotel-catering-and-events" "path" => "/industries/" ] |
|
21.49 ms (2.14%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'project' AND `documents_page`.`controller` = 'App\\Controller\\ProjectController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:231471;%' AND `documents`.`published` = 1
Parameters:
[] |
|
21.24 ms (2.11%) |
2 |
SELECT r.src_id AS dest_id, r.src_id AS id, r.type, o.o_className AS subtype, o.o_published AS published, CONCAT(o.o_path ,o.o_key) AS path , r.index FROM objects o, object_relations_3 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.o_id = r.src_id AND r.type='object' UNION SELECT r.src_id AS dest_id, r.src_id AS id, r.type, a.type AS subtype, "null" AS published, CONCAT(a.path,a.filename) AS path, r.index FROM assets a, object_relations_3 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id AS dest_id, r.src_id AS id, r.type, d.type AS subtype, d.published AS published, CONCAT(d.path,d.key) AS path, r.index FROM documents d, object_relations_3 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC
Parameters:
[ "sectors" 85311 "sectors" 85311 "sectors" 85311 ] |
|
17.99 ms (1.79%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'project' AND `documents_page`.`controller` = 'App\\Controller\\ProjectController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:202592;%' AND `documents`.`published` = 1
Parameters:
[] |
|
16.92 ms (1.68%) |
18 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
244571
]
|
|
16.79 ms (1.67%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'sector' AND `documents_page`.`controller` = 'App\\Controller\\SectorController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:85321;%' AND `documents`.`published` = 1
Parameters:
[] |
|
11.82 ms (1.18%) |
2 |
SELECT * FROM object_store_3 WHERE oo_id = ?
Parameters:
[
202592
]
|
|
8.87 ms (0.88%) |
6 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
4751
]
|
|
8.71 ms (0.87%) |
15 |
SELECT documents.*, documents_page.*, tree_locks.locked FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id LEFT JOIN tree_locks ON documents.id = tree_locks.id AND tree_locks.type = 'document' WHERE documents.id = ?
Parameters:
[
2750
]
|
|
8.59 ms (0.86%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'sector' AND `documents_page`.`controller` = 'App\\Controller\\SectorController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:85317;%' AND `documents`.`published` = 1
Parameters:
[] |
|
8.42 ms (0.84%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'sector' AND `documents_page`.`controller` = 'App\\Controller\\SectorController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:85318;%' AND `documents`.`published` = 1
Parameters:
[] |
|
8.09 ms (0.80%) |
1 |
SELECT * FROM `documents_editables` INNER JOIN `documents` ON `documents_editables`.`documentId` = `documents`.`id` INNER JOIN `documents_page` ON `documents_editables`.`documentId` = `documents_page`.`id` WHERE `documents_editables`.`name` = 'sector' AND `documents_page`.`controller` = 'App\\Controller\\SectorController::singleAction' AND `documents_editables`.`data` LIKE '%"id";i:85320;%' AND `documents`.`published` = 1
Parameters:
[] |
|
7.40 ms (0.74%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,5307,12) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5320
]
|
|
5.31 ms (0.53%) |
2 |
SELECT * FROM object_localized_data_3 WHERE ooo_id = ? AND language IN ('en','nl_NL','fr_FR','nl_BE','fr_BE','nl')
Parameters:
[
202592
]
|
|
5.23 ms (0.52%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
4.82 ms (0.48%) |
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" => "/industries/hotel-catering-and-events" "sourcePathQuery" => "/industries/hotel-catering-and-events" "sourceEntireUri" => "https://testing.coolworld.ptchr.dev/industries/hotel-catering-and-events" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
|
4.62 ms (0.46%) |
1 |
SELECT * FROM assets_metadata WHERE cid = ?
Parameters:
[
"244744"
]
|
|
3.98 ms (0.40%) |
6 |
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[ "prettyUrl" => "/nl_NL" ] |
|
3.42 ms (0.34%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 100000361
Parameters:
[] |
|
3.31 ms (0.33%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 100000361
Parameters:
[] |
|
3.21 ms (0.32%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
3.04 ms (0.30%) |
3 |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
|
2.99 ms (0.30%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,5820) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5833
]
|
|
2.87 ms (0.29%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,4492,10) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
4502
]
|
|
2.84 ms (0.28%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,3395,2) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
2750
]
|
|
2.79 ms (0.28%) |
2 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
4751
]
|
|
2.69 ms (0.27%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
2.68 ms (0.27%) |
2 |
SELECT * FROM object_relations_3 WHERE src_id = ?
Parameters:
[
202592
]
|
|
2.41 ms (0.24%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId AS id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 4751 4751 4751 ] |
|
2.38 ms (0.24%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"5"
]
|
|
2.38 ms (0.24%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,4467,8) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
4477
]
|
|
2.03 ms (0.20%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,5566,14) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5579
]
|
|
1.99 ms (0.20%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/industries/hotel-catering-and-events' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
|
1.83 ms (0.18%) |
2 |
SELECT * FROM properties WHERE ((cid IN (1,5059,4) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5284
]
|
|
1.50 ms (0.15%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,5538,6) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5551
]
|
|
1.47 ms (0.15%) |
1 |
SELECT * FROM properties WHERE ((cid IN (1,5467,16) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
5480
]
|
|
1.09 ms (0.11%) |
3 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
4
]
|
|
0.79 ms (0.08%) |
2 |
SELECT objects.*, tree_locks.locked AS o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
202592
]
|
|
0.74 ms (0.07%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 202592
Parameters:
[] |
|
0.57 ms (0.06%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.57 ms (0.06%) |
2 |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
202592
]
|
|
0.44 ms (0.04%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.33 ms (0.03%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 100000361
Parameters:
[] |
|
0.26 ms (0.03%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 202592
Parameters:
[] |
|
0.26 ms (0.03%) |
1 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Project"
]
|
|
0.26 ms (0.03%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 100000361
Parameters:
[] |
|
0.26 ms (0.03%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.25 ms (0.03%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 202592
Parameters:
[] |
|
0.25 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 100000361
Parameters:
[] |
|
0.24 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.23 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 202592
Parameters:
[] |
|
0.22 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.22 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 100000361
Parameters:
[] |
|
0.22 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 100000361
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 202592
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 100000361
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 100000361
Parameters:
[] |
|
0.21 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 202592
Parameters:
[] |
|
0.19 ms (0.02%) |
1 |
SELECT `uspItems` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.19 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 202592
Parameters:
[] |
|
0.19 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.18 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'nl' AND ooo_id = 202592
Parameters:
[] |
|
0.17 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.17 ms (0.02%) |
1 |
SELECT `usp_list` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.17 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'en' AND ooo_id = 100000361
Parameters:
[] |
|
0.16 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'fr_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.16 ms (0.02%) |
1 |
SELECT `project_facts` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.15 ms (0.02%) |
1 |
SELECT `client_facts` FROM object_localized_data_3 WHERE language = 'nl_BE' AND ooo_id = 202592
Parameters:
[] |
|
0.00 ms (0.00%) |
41 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[ "cid" => 244528 ] |
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 |
|---|---|
| FormBuilderBundle\Model\FormDefinition | No errors. |
| FormBuilderBundle\Model\OutputWorkflow | No errors. |
| FormBuilderBundle\Model\OutputWorkflowChannel | No errors. |