Query Metrics
18
Database Queries
8
Different statements
27.17 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 3.12 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:
[
"peglanje-susenje-i-odlaganje-vesa"
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.36 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:
[ 1790347963 "cache_tree_oidl_756" ]
|
||||||||||||||||||||||||||||||||||
| 3 | 9.12 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1790347963 "cache_tree_oidl_756" ]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.67 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:
[ 756 756 ] |
||||||||||||||||||||||||||||||||||
| 5 | 0.48 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:
[ 850 850 ] |
||||||||||||||||||||||||||||||||||
| 6 | 0.56 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:
[ 1262 1262 ] |
||||||||||||||||||||||||||||||||||
| 7 | 0.61 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:
[ 852 852 ] |
||||||||||||||||||||||||||||||||||
| 8 | 0.45 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:
[ 851 851 ] |
||||||||||||||||||||||||||||||||||
| 9 | 0.51 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:
[ 853 853 ] |
||||||||||||||||||||||||||||||||||
| 10 | 9.13 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 => 1790347963 0 => "cache_tree_oidl_756" 1 => "a:2:{s:13:"subCategories";a:5:{i:0;a:7:{s:11:"category_id";i:850;s:13:"category_name";s:17:"Daske za peglanje";s:17:"category_name_seo";s:17:"daske-za-peglanje";s:17:"category_name_aim";s:17:"Daske za peglanje";s:14:"category_image";s:18:"850-1320351662.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"86766";s:10:"product_id";i:86766;s:4:"name";s:54:"Leifheit navlaka za dasku za peglanje HEAT REFLECT S/M";s:12:"product_name";s:54:"Leifheit navlaka za dasku za peglanje HEAT REFLECT S/M";s:3:"url";s:53:"leifheit-navlaka-za-dasku-za-peglanje-heat-reflect-sm";s:4:"path";s:14:"/1/29/756/850/";}i:1;a:6:{s:2:"id";s:5:"86769";s:10:"product_id";i:86769;s:4:"name";s:60:"Leifheit navlaka za dasku za peglanje HEAT REFLECT UNIVERSAL";s:12:"product_name";s:60:"Leifheit navlaka za dasku za peglanje HEAT REFLECT UNIVERSAL";s:3:"url";s:60:"leifheit-navlaka-za-dasku-za-peglanje-heat-reflect-universal";s:4:"path";s:14:"/1/29/756/850/";}i:2;a:6:{s:2:"id";s:5:"85591";s:10:"product_id";i:85591;s:4:"name";s:53:"Leifheit navlaka za dasku Airboard THERMO REFLECT S/M";s:12:"product_name";s:53:"Leifheit navlaka za dasku Airboard THERMO REFLECT S/M";s:3:"url";s:52:"leifheit-navlaka-za-dasku-airboard-thermo-reflect-sm";s:4:"path";s:14:"/1/29/756/850/";}i:3;a:6:{s:2:"id";s:5:"81334";s:10:"product_id";i:81334;s:4:"name";s:41:"Daska za peglanje Standard TIB-257 Texell";s:12:"product_name";s:41:"Daska za peglanje Standard TIB-257 Texell";s:3:"url";s:41:"daska-za-peglanje-standard-tib-257-texell";s:4:"path";s:14:"/1/29/756/850/";}i:4;a:6:{s:2:"id";s:5:"85592";s:10:"product_id";i:85592;s:4:"name";s:54:"Leifheit navlaka za dasku Airboard THERMO REFLECT L/XL";s:12:"product_name";s:54:"Leifheit navlaka za dasku Airboard THERMO REFLECT L/XL";s:3:"url";s:53:"leifheit-navlaka-za-dasku-airboard-thermo-reflect-lxl";s:4:"path";s:14:"/1/29/756/850/";}}}i:1;a:7:{s:11:"category_id";i:1262;s:13:"category_name";s:32:"Kanapi i sajle za sušenje veša";s:17:"category_name_seo";s:30:"kanapi-i-sajle-za-susenje-vesa";s:17:"category_name_aim";s:32:"Kanapi i sajle za sušenje veša";s:14:"category_image";s:19:"1262-1428071223.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"55064";s:10:"product_id";i:55064;s:4:"name";s:27:"Kanap za veš 20m PVC žuti";s:12:"product_name";s:27:"Kanap za veš 20m PVC žuti";s:3:"url";s:25:"kanap-za-ves-20m-pvc-zuti";s:4:"path";s:15:"/1/29/756/1262/";}i:1;a:6:{s:2:"id";s:5:"55061";s:10:"product_id";i:55061;s:4:"name";s:26:"Kanap za veš 20m PVC beli";s:12:"product_name";s:26:"Kanap za veš 20m PVC beli";s:3:"url";s:25:"kanap-za-ves-20m-pvc-beli";s:4:"path";s:15:"/1/29/756/1262/";}i:2;a:6:{s:2:"id";s:5:"55066";s:10:"product_id";i:55066;s:4:"name";s:26:"Kanap za veš 20m pamučni";s:12:"product_name";s:26:"Kanap za veš 20m pamučni";s:3:"url";s:24:"kanap-za-ves-20m-pamucni";s:4:"path";s:15:"/1/29/756/1262/";}i:3;a:6:{s:2:"id";s:5:"55063";s:10:"product_id";i:55063;s:4:"name";s:28:"Kanap za veš 20m PVC crveni";s:12:"product_name";s:28:"Kanap za veš 20m PVC crveni";s:3:"url";s:27:"kanap-za-ves-20m-pvc-crveni";s:4:"path";s:15:"/1/29/756/1262/";}i:4;a:6:{s:2:"id";s:5:"55048";s:10:"product_id";i:55048;s:4:"name";s:25:"Sajla za veš 30m fi 4mm.";s:12:"product_name";s:25:"Sajla za veš 30m fi 4mm.";s:3:"url";s:23:"sajla-za-ves-30m-fi-4mm";s:4:"path";s:15:"/1/29/756/1262/";}}}i:2;a:7:{s:11:"category_id";i:852;s:13:"category_name";s:13:"Korpe za veš";s:17:"category_name_seo";s:12:"korpe-za-ves";s:17:"category_name_aim";s:13:"Korpe za veš";s:14:"category_image";s:18:"852-1570869453.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"122137";s:10:"product_id";i:122137;s:4:"name";s:34:"Korpa crvena 400x300x220 plasticna";s:12:"product_name";s:34:"Korpa crvena 400x300x220 plasticna";s:3:"url";s:34:"korpa-crvena-400x300x220-plasticna";s:4:"path";s:14:"/1/29/756/852/";}i:1;a:6:{s:2:"id";s:6:"115200";s:10:"product_id";i:115200;s:4:"name";s:47:"ESTIA ES02-18832 VIŠENAMENSKA KORPA 28x20x10CM";s:12:"product_name";s:47:"ESTIA ES02-18832 VIŠENAMENSKA KORPA 28x20x10CM";s:3:"url";s:46:"estia-es02-18832-visenamenska-korpa-28x20x10cm";s:4:"path";s:14:"/1/29/756/852/";}i:2;a:6:{s:2:"id";s:6:"115199";s:10:"product_id";i:115199;s:4:"name";s:47:"ESTIA ES02-18825 VIŠENAMENSKA KORPA 32x24x12CM";s:12:"product_name";s:47:"ESTIA ES02-18825 VIŠENAMENSKA KORPA 32x24x12CM";s:3:"url";s:46:"estia-es02-18825-visenamenska-korpa-32x24x12cm";s:4:"path";s:14:"/1/29/756/852/";}i:3;a:6:{s:2:"id";s:6:"115222";s:10:"product_id";i:115222;s:4:"name";s:62:"ESTIA ES02-19525 KORPA ZA VEŠ SA RUČKAMA 65L CRNA 36X36X50CM";s:12:"product_name";s:62:"ESTIA ES02-19525 KORPA ZA VEŠ SA RUČKAMA 65L CRNA 36X36X50CM";s:3:"url";s:60:"estia-es02-19525-korpa-za-ves-sa-ruckama-65l-crna-36x36x50cm";s:4:"path";s:14:"/1/29/756/852/";}i:4;a:6:{s:2:"id";s:6:"115223";s:10:"product_id";i:115223;s:4:"name";s:62:"ESTIA ES02-19532 KORPA ZA VEŠ SA RUČKAMA 65L BEŽ 36X36X50CM";s:12:"product_name";s:62:"ESTIA ES02-19532 KORPA ZA VEŠ SA RUČKAMA 65L BEŽ 36X36X50CM";s:3:"url";s:59:"estia-es02-19532-korpa-za-ves-sa-ruckama-65l-bez-36x36x50cm";s:4:"path";s:14:"/1/29/756/852/";}}}i:3;a:7:{s:11:"category_id";i:851;s:13:"category_name";s:24:"Stalci za sušenje veša";s:17:"category_name_seo";s:22:"stalci-za-susenje-vesa";s:17:"category_name_aim";s:24:"Stalci za sušenje veša";s:14:"category_image";s:18:"851-1320351731.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"121412";s:10:"product_id";i:121412;s:4:"name";s:36:"Sušač Za Veš-Sklopivi 180X50X90Cm";s:12:"product_name";s:36:"Sušač Za Veš-Sklopivi 180X50X90Cm";s:3:"url";s:33:"susac-za-ves-sklopivi-180x50x90cm";s:4:"path";s:14:"/1/29/756/851/";}i:1;a:6:{s:2:"id";s:5:"28373";s:10:"product_id";i:28373;s:4:"name";s:44:"Sušilica za veš Stabilo 0503SE 18m TEXELL";s:12:"product_name";s:44:"Sušilica za veš Stabilo 0503SE 18m TEXELL";s:3:"url";s:41:"susilica-za-ves-stabilo-0503se-18m-texell";s:4:"path";s:14:"/1/29/756/851/";}i:2;a:6:{s:2:"id";s:6:"115260";s:10:"product_id";i:115260;s:4:"name";s:42:"ESTIA ES04-8246 HORIZONTALNA SUŠILICA 20M";s:12:"product_name";s:42:"ESTIA ES04-8246 HORIZONTALNA SUŠILICA 20M";s:3:"url";s:41:"estia-es04-8246-horizontalna-susilica-20m";s:4:"path";s:14:"/1/29/756/851/";}i:3;a:6:{s:2:"id";s:6:"100495";s:10:"product_id";i:100495;s:4:"name";s:72:"Sušilica za veš balkonska i radijatorska 56×110×28cm BREZZA 100 Gimi";s:12:"product_name";s:72:"Sušilica za veš balkonska i radijatorska 56×110×28cm BREZZA 100 Gimi";s:3:"url";s:65:"susilica-za-ves-balkonska-i-radijatorska-5611028cm-breza-100-gimi";s:4:"path";s:14:"/1/29/756/851/";}i:4;a:6:{s:2:"id";s:6:"115359";s:10:"product_id";i:115359;s:4:"name";s:52:"Estia ES04-7317 sušilica za veš mini prenosiva 10m";s:12:"product_name";s:52:"Estia ES04-7317 sušilica za veš mini prenosiva 10m";s:3:"url";s:50:"estia-es04-7317-susilica-za-ves-mini-prenosiva-10m";s:4:"path";s:14:"/1/29/756/851/";}}}i:4;a:7:{s:11:"category_id";i:853;s:13:"category_name";s:22:"Vešalice za garderobu";s:17:"category_name_seo";s:21:"vesalice-za-garderobu";s:17:"category_name_aim";s:22:"Vešalice za garderobu";s:14:"category_image";s:18:"853-1674070264.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}" ] |
||||||||||||||||||||||||||||||||||
| 11 | 0.30 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
]
|
||||||||||||||||||||||||||||||||||
| 12 | 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:
[ 1790347963 "cache_tree_oidl_29" ]
|
||||||||||||||||||||||||||||||||||
| 13 | 0.22 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
]
|
||||||||||||||||||||||||||||||||||
| 14 | 0.23 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:
[ 1790347963 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 15 | 0.22 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
]
|
||||||||||||||||||||||||||||||||||
| 16 | 0.21 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:
[ 1790347963 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 17 | 0.41 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:
[
756
]
|
||||||||||||||||||||||||||||||||||
| 18 | 0.33 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.