Query Metrics
26
Database Queries
8
Different statements
25.63 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.91 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, cache_tree, cache_tree_aim, show_eponuda FROM kategorije WHERE category_name_seo = ? and active = 1
Parameters:
[
"kucni-tekstil"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.24 ms |
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:
[ 1790347950 "cache_tree_oidl_691" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 9.23 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1790347950 "cache_tree_oidl_691" ]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.35 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 691 691 ] |
||||||||||||||||||||||||||||||||||
| 5 | 0.18 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 822 822 ] |
||||||||||||||||||||||||||||||||||
| 6 | 0.43 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 824 824 ] |
||||||||||||||||||||||||||||||||||
| 7 | 0.26 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 1048 1048 ] |
||||||||||||||||||||||||||||||||||
| 8 | 0.20 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 820 820 ] |
||||||||||||||||||||||||||||||||||
| 9 | 0.21 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 1014 1014 ] |
||||||||||||||||||||||||||||||||||
| 10 | 0.34 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 819 819 ] |
||||||||||||||||||||||||||||||||||
| 11 | 0.31 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 827 827 ] |
||||||||||||||||||||||||||||||||||
| 12 | 0.30 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 823 823 ] |
||||||||||||||||||||||||||||||||||
| 13 | 0.32 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 1455 1455 ] |
||||||||||||||||||||||||||||||||||
| 14 | 0.31 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 998 998 ] |
||||||||||||||||||||||||||||||||||
| 15 | 0.31 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 818 818 ] |
||||||||||||||||||||||||||||||||||
| 16 | 0.30 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 821 821 ] |
||||||||||||||||||||||||||||||||||
| 17 | 0.32 ms |
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image FROM kategorije k WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1 UNION ALL (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image FROM kategorije_veze c1, kategorije c2 WHERE c1.category_id = c2.id and c1.parent_category_id = ? and c1.active = 1 and c2.show_category = 1) ORDER BY category_name
Parameters:
[ 826 826 ] |
||||||||||||||||||||||||||||||||||
| 18 | 8.29 ms |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 3600 3 => 1790347950 0 => "cache_tree_oidl_691" 1 => "a:2:{s:13:"subCategories";a:13:{i:0;a:7:{s:11:"category_id";i:822;s:13:"category_name";s:9:"Čaršavi";s:17:"category_name_seo";s:7:"carsavi";s:17:"category_name_aim";s:9:"Čaršavi";s:14:"category_image";s:18:"822-1675251765.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:1;a:7:{s:11:"category_id";i:824;s:13:"category_name";s:6:"Ćebad";s:17:"category_name_seo";s:5:"cebad";s:17:"category_name_aim";s:6:"Ćebad";s:14:"category_image";s:18:"824-1319894864.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:4:{i:0;a:6:{s:2:"id";s:5:"64469";s:10:"product_id";i:64469;s:4:"name";s:31:"Štepano ćebe KORNBLOM 140x200";s:12:"product_name";s:31:"Štepano ćebe KORNBLOM 140x200";s:3:"url";s:29:"stepano-cebe-kornblom-140x200";s:4:"path";s:14:"/1/29/691/824/";}i:1;a:6:{s:2:"id";s:6:"121581";s:10:"product_id";i:121581;s:4:"name";s:22:"Ćebe Maca 1500x1000mm";s:12:"product_name";s:22:"Ćebe Maca 1500x1000mm";s:3:"url";s:21:"cebe-maca-1500x1000mm";s:4:"path";s:14:"/1/29/691/824/";}i:2;a:6:{s:2:"id";s:6:"121582";s:10:"product_id";i:121582;s:4:"name";s:22:"Ćebe Seka 1500x1000mm";s:12:"product_name";s:22:"Ćebe Seka 1500x1000mm";s:3:"url";s:21:"cebe-seka-1500x1000mm";s:4:"path";s:14:"/1/29/691/824/";}i:3;a:6:{s:2:"id";s:6:"121583";s:10:"product_id";i:121583;s:4:"name";s:22:"Ćebe Sova 1500x1000mm";s:12:"product_name";s:22:"Ćebe Sova 1500x1000mm";s:3:"url";s:21:"cebe-sova-1500x1000mm";s:4:"path";s:14:"/1/29/691/824/";}}}i:2;a:7:{s:11:"category_id";i:1048;s:13:"category_name";s:7:"Jastuci";s:17:"category_name_seo";s:7:"jastuci";s:17:"category_name_aim";s:7:"Jastuci";s:14:"category_image";s:19:"1048-1675252367.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:3;a:7:{s:11:"category_id";i:820;s:13:"category_name";s:18:"Jastuci za stolice";s:17:"category_name_seo";s:18:"jastuci-za-stolice";s:17:"category_name_aim";s:18:"Jastuci za stolice";s:14:"category_image";s:18:"820-1675251081.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:4;a:7:{s:11:"category_id";i:1014;s:13:"category_name";s:11:"Jastučnice";s:17:"category_name_seo";s:10:"jastucnice";s:17:"category_name_aim";s:11:"Jastučnice";s:14:"category_image";s:19:"1014-1675252502.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:5;a:7:{s:11:"category_id";i:819;s:13:"category_name";s:7:"Jorgani";s:17:"category_name_seo";s:7:"jorgani";s:17:"category_name_aim";s:7:"Jorgani";s:14:"category_image";s:18:"819-1319893586.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:6;a:7:{s:11:"category_id";i:827;s:13:"category_name";s:18:"Navlake za stolice";s:17:"category_name_seo";s:18:"navlake-za-stolice";s:17:"category_name_aim";s:18:"Navlake za stolice";s:14:"category_image";s:18:"827-1675252627.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:7;a:7:{s:11:"category_id";i:823;s:13:"category_name";s:8:"Peškiri";s:17:"category_name_seo";s:7:"peskiri";s:17:"category_name_aim";s:8:"Peškiri";s:14:"category_image";s:18:"823-1675249965.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:8;a:7:{s:11:"category_id";i:1455;s:13:"category_name";s:16:"Peškiri za decu";s:17:"category_name_seo";s:15:"peskiri-za-decu";s:17:"category_name_aim";s:16:"Peškiri za decu";s:14:"category_image";s:19:"1455-1673130184.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:3:{i:0;a:6:{s:2:"id";s:5:"93095";s:10:"product_id";i:93095;s:4:"name";s:23:"Peškir Frozen 70x140cm";s:12:"product_name";s:23:"Peškir Frozen 70x140cm";s:3:"url";s:22:"peskir-frozen-70x140cm";s:4:"path";s:11:"/1/31/1455/";}i:1;a:6:{s:2:"id";s:5:"93100";s:10:"product_id";i:93100;s:4:"name";s:23:"Peškir Cars 70 x 140cm";s:12:"product_name";s:23:"Peškir Cars 70 x 140cm";s:3:"url";s:22:"peskir-cars-70-x-140cm";s:4:"path";s:11:"/1/31/1455/";}i:2;a:6:{s:2:"id";s:5:"93093";s:10:"product_id";i:93093;s:4:"name";s:37:"Peškir Pončo Angry Birds Bomb Black";s:12:"product_name";s:37:"Peškir Pončo Angry Birds Bomb Black";s:3:"url";s:35:"peskir-ponco-angry-birds-bomb-black";s:4:"path";s:11:"/1/31/1455/";}}}i:9;a:7:{s:11:"category_id";i:998;s:13:"category_name";s:16:"Podmetači stoni";s:17:"category_name_seo";s:15:"podmetaci-stoni";s:17:"category_name_aim";s:16:"Podmetači stoni";s:14:"category_image";s:18:"998-1675251570.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:10;a:7:{s:11:"category_id";i:818;s:13:"category_name";s:10:"Posteljina";s:17:"category_name_seo";s:10:"posteljina";s:17:"category_name_aim";s:10:"Posteljina";s:14:"category_image";s:18:"818-1319893499.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:11;a:7:{s:11:"category_id";i:821;s:13:"category_name";s:11:"Prekrivači";s:17:"category_name_seo";s:10:"prekrivaci";s:17:"category_name_aim";s:11:"Prekrivači";s:14:"category_image";s:18:"821-1675251397.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:12;a:7:{s:11:"category_id";i:826;s:13:"category_name";s:9:"Stolnjaci";s:17:"category_name_seo";s:9:"stolnjaci";s:17:"category_name_aim";s:9:"Stolnjaci";s:14:"category_image";s:18:"826-1675251193.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}" ] |
||||||||||||||||||||||||||||||||||
| 19 | 0.20 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
29
]
|
||||||||||||||||||||||||||||||||||
| 20 | 0.25 ms |
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:
[ 1790347950 "cache_tree_oidl_29" ]
|
||||||||||||||||||||||||||||||||||
| 21 | 0.18 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.17 ms |
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:
[ 1790347950 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 23 | 0.16 ms |
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated, show_eponuda FROM kategorije WHERE id = ? and active = 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||
| 24 | 0.15 ms |
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:
[ 1790347950 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 25 | 0.43 ms |
SELECT COUNT(*) AS broj_proizvoda FROM proizvodi WHERE category_id = ? AND show_product = 1 AND active = 1 AND (copy_from_id is NULL OR copy_from_id = '')
Parameters:
[
691
]
|
||||||||||||||||||||||||||||||||||
| 26 | 0.28 ms |
SELECT page_title, page_meta_description, page_meta_keywords, web_page FROM website_tags WHERE website = ? and web_page IN (?, ?)
Parameters:
[ 1 "kategorije" "ostale" ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.