Query Metrics
38
Database Queries
12
Different statements
46.36 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.26 ms |
SELECT id, brand_name, brand_name_seo, brand_description, brand_image, meta_title, meta_description, meta_keywords, num_of_products, num_of_products_aim, img_size FROM proizvodjaci WHERE id = ? and active = 1
Parameters:
[
75
]
|
||||||||||||||||||||||||||||||||||
| 2 | 0.11 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:
[
339
]
|
||||||||||||||||||||||||||||||||||
| 3 | 7.75 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:
[ 1790355623 "cache_tree_oidl_339" ]
|
||||||||||||||||||||||||||||||||||
| 4 | 0.11 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:
[
335
]
|
||||||||||||||||||||||||||||||||||
| 5 | 0.07 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:
[ 1790355623 "cache_tree_oidl_335" ]
|
||||||||||||||||||||||||||||||||||
| 6 | 8.09 ms |
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[ 1790355623 "cache_tree_oidl_335" ]
|
||||||||||||||||||||||||||||||||||
| 7 | 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:
[ 335 335 ] |
||||||||||||||||||||||||||||||||||
| 8 | 0.22 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:
[ 1246 1246 ] |
||||||||||||||||||||||||||||||||||
| 9 | 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:
[ 340 340 ] |
||||||||||||||||||||||||||||||||||
| 10 | 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:
[ 338 338 ] |
||||||||||||||||||||||||||||||||||
| 11 | 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:
[ 337 337 ] |
||||||||||||||||||||||||||||||||||
| 12 | 0.22 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:
[ 1248 1248 ] |
||||||||||||||||||||||||||||||||||
| 13 | 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:
[ 339 339 ] |
||||||||||||||||||||||||||||||||||
| 14 | 0.19 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:
[ 341 341 ] |
||||||||||||||||||||||||||||||||||
| 15 | 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:
[ 342 342 ] |
||||||||||||||||||||||||||||||||||
| 16 | 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:
[ 458 458 ] |
||||||||||||||||||||||||||||||||||
| 17 | 0.19 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:
[ 1244 1244 ] |
||||||||||||||||||||||||||||||||||
| 18 | 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:
[ 1245 1245 ] |
||||||||||||||||||||||||||||||||||
| 19 | 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:
[ 1247 1247 ] |
||||||||||||||||||||||||||||||||||
| 20 | 25.09 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 => 1790355623 0 => "cache_tree_oidl_335" 1 => "a:2:{s:13:"subCategories";a:12:{i:0;a:7:{s:11:"category_id";i:1246;s:13:"category_name";s:11:"Drvene boje";s:17:"category_name_seo";s:11:"drvene-boje";s:17:"category_name_aim";s:11:"Drvene boje";s:14:"category_image";s:19:"1246-1672777914.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:1;a:7:{s:11:"category_id";i:340;s:13:"category_name";s:10:"Flomasteri";s:17:"category_name_seo";s:10:"flomasteri";s:17:"category_name_aim";s:10:"Flomasteri";s:14:"category_image";s:18:"340-1672777682.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:5:"80707";s:10:"product_id";i:80707;s:4:"name";s:40:"Marker permanentni 1-5mm, crni Bleispitz";s:12:"product_name";s:40:"Marker permanentni 1-5mm, crni Bleispitz";s:3:"url";s:39:"marker-permanentni-1-5mm-crni-bleispitz";s:4:"path";s:14:"/1/14/335/340/";}i:1;a:6:{s:2:"id";s:5:"93816";s:10:"product_id";i:93816;s:4:"name";s:41:"Stanley 0-47-316 marker Permanent set 1/2";s:12:"product_name";s:41:"Stanley 0-47-316 marker Permanent set 1/2";s:3:"url";s:40:"stanley-0-47-316-marker-permanent-set-12";s:4:"path";s:14:"/1/14/335/340/";}}}i:2;a:7:{s:11:"category_id";i:338;s:13:"category_name";s:27:"Grafitne i tehničke olovke";s:17:"category_name_seo";s:26:"grafitne-i-tehnicke-olovke";s:17:"category_name_aim";s:27:"Grafitne i tehničke olovke";s:14:"category_image";s:18:"338-1271160524.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"115982";s:10:"product_id";i:115982;s:4:"name";s:36:"Zidarska olovka 250mm Hogert HT3B772";s:12:"product_name";s:36:"Zidarska olovka 250mm Hogert HT3B772";s:3:"url";s:36:"zidarska-olovka-250mm-hogert-ht3b772";s:4:"path";s:14:"/1/14/335/338/";}i:1;a:6:{s:2:"id";s:6:"104153";s:10:"product_id";i:104153;s:4:"name";s:48:"Rezervno punjenje za tesarsku olovku 5kom. FESTA";s:12:"product_name";s:48:"Rezervno punjenje za tesarsku olovku 5kom. FESTA";s:3:"url";s:47:"rezervno-punjenje-za-tesarsku-olovku-5kom-festa";s:4:"path";s:14:"/1/14/335/338/";}i:2;a:6:{s:2:"id";s:6:"104151";s:10:"product_id";i:104151;s:4:"name";s:38:"Olovka stolarska sa dva punjenja FESTA";s:12:"product_name";s:38:"Olovka stolarska sa dva punjenja FESTA";s:3:"url";s:38:"olovka-stolarska-sa-dva-punjenja-festa";s:4:"path";s:14:"/1/14/335/338/";}i:3;a:6:{s:2:"id";s:6:"115991";s:10:"product_id";i:115991;s:4:"name";s:50:"Tehnička plava kreda dužine 120mm HT3B776 Hogert";s:12:"product_name";s:50:"Tehnička plava kreda dužine 120mm HT3B776 Hogert";s:3:"url";s:48:"tehnicka-plava-kreda-duzine-120mm-ht3b776-hogert";s:4:"path";s:14:"/1/14/335/338/";}i:4;a:6:{s:2:"id";s:6:"115999";s:10:"product_id";i:115999;s:4:"name";s:54:"Tehnička bela kreda, 120 mm, 12 komada Hogert HT3B777";s:12:"product_name";s:54:"Tehnička bela kreda, 120 mm, 12 komada Hogert HT3B777";s:3:"url";s:51:"tehnicka-bela-kreda-120-mm-12-komada-hogert-ht3b777";s:4:"path";s:14:"/1/14/335/338/";}}}i:3;a:7:{s:11:"category_id";i:337;s:13:"category_name";s:15:"Hemijske olovke";s:17:"category_name_seo";s:15:"hemijske-olovke";s:17:"category_name_aim";s:15:"Hemijske olovke";s:14:"category_image";s:18:"337-1271160898.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:5:"89269";s:10:"product_id";i:89269;s:4:"name";s:75:"Olovka hemijska Souveran K605+kožna bela futrola+poklon kutija G30 Pelikan";s:12:"product_name";s:75:"Olovka hemijska Souveran K605+kožna bela futrola+poklon kutija G30 Pelikan";s:3:"url";s:72:"olovka-hemijska-souveran-k605kozna-bela-futrolapoklon-kutija-g30-pelikan";s:4:"path";s:14:"/1/14/335/337/";}i:1;a:6:{s:2:"id";s:6:"118195";s:10:"product_id";i:118195;s:4:"name";s:94:"Olovka hemijska Souveran K600+kožna bela futrola+poklon kutija G30 Pelikan 980086 zeleno-crna";s:12:"product_name";s:94:"Olovka hemijska Souveran K600+kožna bela futrola+poklon kutija G30 Pelikan 980086 zeleno-crna";s:3:"url";s:91:"olovka-hemijska-souveran-k600kozna-bela-futrolapoklon-kutija-g30-pelikan-980086-zeleno-crna";s:4:"path";s:14:"/1/14/335/337/";}}}i:4;a:7:{s:11:"category_id";i:1248;s:13:"category_name";s:5:"Krede";s:17:"category_name_seo";s:5:"krede";s:17:"category_name_aim";s:5:"Krede";s:14:"category_image";s:19:"1248-1414576168.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:5;a:7:{s:11:"category_id";i:339;s:13:"category_name";s:10:"Naliv pera";s:17:"category_name_seo";s:10:"naliv-pera";s:17:"category_name_aim";s:10:"Naliv pera";s:14:"category_image";s:18:"339-1271161047.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"118321";s:10:"product_id";i:118321;s:4:"name";s:75:"Nalivpero P6 Ineo Elements Lavender Scent u metalnoj kutiji Pelikan lavanda";s:12:"product_name";s:75:"Nalivpero P6 Ineo Elements Lavender Scent u metalnoj kutiji Pelikan lavanda";s:3:"url";s:75:"nalivpero-p6-ineo-elements-lavender-scent-u-metalnoj-kutiji-pelikan-lavanda";s:4:"path";s:14:"/1/14/335/339/";}i:1;a:6:{s:2:"id";s:6:"118553";s:10:"product_id";i:118553;s:4:"name";s:102:"Set nalivpero+olovka hemijska Jazz Noble EleganceK/P36+poklon kutija G25 Pelikan 821896 crni 000019309";s:12:"product_name";s:102:"Set nalivpero+olovka hemijska Jazz Noble EleganceK/P36+poklon kutija G25 Pelikan 821896 crni 000019309";s:3:"url";s:98:"set-nalivperoolovka-hemijska-jaz-noble-elegancekp36poklon-kutija-g25-pelikan-821896-crni-000019309";s:4:"path";s:14:"/1/14/335/339/";}i:2;a:6:{s:2:"id";s:6:"118556";s:10:"product_id";i:118556;s:4:"name";s:98:"Set nalivpero+olovka hemijska Jazz Noble Elegance+poklon kutija G25 Pelikan 826808 plavi 000021215";s:12:"product_name";s:98:"Set nalivpero+olovka hemijska Jazz Noble Elegance+poklon kutija G25 Pelikan 826808 plavi 000021215";s:3:"url";s:95:"set-nalivperoolovka-hemijska-jaz-noble-elegancepoklon-kutija-g25-pelikan-826808-plavi-000021215";s:4:"path";s:14:"/1/14/335/339/";}i:3;a:6:{s:2:"id";s:6:"118574";s:10:"product_id";i:118574;s:4:"name";s:98:"Set nalivpero+olovka hemijska Jazz Noble Elegance+poklon kutija G25 Pelikan 826792 pesak 000021214";s:12:"product_name";s:98:"Set nalivpero+olovka hemijska Jazz Noble Elegance+poklon kutija G25 Pelikan 826792 pesak 000021214";s:3:"url";s:95:"set-nalivperoolovka-hemijska-jaz-noble-elegancepoklon-kutija-g25-pelikan-826792-pesak-000021214";s:4:"path";s:14:"/1/14/335/339/";}i:4;a:6:{s:2:"id";s:6:"118575";s:10:"product_id";i:118575;s:4:"name";s:88:"Set nalivpero+roler Jazz Noble Elegance+poklon kutija G25 Pelikan 826983 plavi 000021220";s:12:"product_name";s:88:"Set nalivpero+roler Jazz Noble Elegance+poklon kutija G25 Pelikan 826983 plavi 000021220";s:3:"url";s:85:"set-nalivperoroler-jaz-noble-elegancepoklon-kutija-g25-pelikan-826983-plavi-000021220";s:4:"path";s:14:"/1/14/335/339/";}}}i:6;a:7:{s:11:"category_id";i:341;s:13:"category_name";s:16:"Rezači i gumice";s:17:"category_name_seo";s:15:"rezaci-i-gumice";s:17:"category_name_aim";s:16:"Rezači i gumice";s:14:"category_image";s:18:"341-1672777550.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:7;a:7:{s:11:"category_id";i:342;s:13:"category_name";s:18:"Roleri i finografi";s:17:"category_name_seo";s:18:"roleri-i-finografi";s:17:"category_name_aim";s:18:"Roleri i finografi";s:14:"category_image";s:18:"342-1271161820.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:8;a:7:{s:11:"category_id";i:458;s:13:"category_name";s:14:"Setovi olovaka";s:17:"category_name_seo";s:14:"setovi-olovaka";s:17:"category_name_aim";s:14:"Setovi olovaka";s:14:"category_image";s:18:"458-1283934367.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"33978";s:10:"product_id";i:33978;s:4:"name";s:43:"Metalna hemijska olovka sa lampicom, u setu";s:12:"product_name";s:43:"Metalna hemijska olovka sa lampicom, u setu";s:3:"url";s:42:"metalna-hemijska-olovka-sa-lampicom-u-setu";s:4:"path";s:14:"/1/14/335/458/";}i:1;a:6:{s:2:"id";s:5:"39525";s:10:"product_id";i:39525;s:4:"name";s:38:"Set hemijska + tehnička olovka crvena";s:12:"product_name";s:38:"Set hemijska + tehnička olovka crvena";s:3:"url";s:35:"set-hemijska-tehnicka-olovka-crvena";s:4:"path";s:14:"/1/14/335/458/";}i:2;a:6:{s:2:"id";s:5:"90749";s:10:"product_id";i:90749;s:4:"name";s:44:"Metalna hemijska olovka u poklon kutiji AKIS";s:12:"product_name";s:44:"Metalna hemijska olovka u poklon kutiji AKIS";s:3:"url";s:44:"metalna-hemijska-olovka-u-poklon-kutiji-akis";s:4:"path";s:14:"/1/14/335/458/";}i:3;a:6:{s:2:"id";s:5:"90696";s:10:"product_id";i:90696;s:4:"name";s:42:"Set hemijska olovka i roler olovka MOSCATO";s:12:"product_name";s:42:"Set hemijska olovka i roler olovka MOSCATO";s:3:"url";s:42:"set-hemijska-olovka-i-roler-olovka-moscato";s:4:"path";s:14:"/1/14/335/458/";}i:4;a:6:{s:2:"id";s:5:"90734";s:10:"product_id";i:90734;s:4:"name";s:68:"Set hemijska olovka i roler od drveta u drvenoj poklon kutiji DENVER";s:12:"product_name";s:68:"Set hemijska olovka i roler od drveta u drvenoj poklon kutiji DENVER";s:3:"url";s:68:"set-hemijska-olovka-i-roler-od-drveta-u-drvenoj-poklon-kutiji-denver";s:4:"path";s:14:"/1/14/335/458/";}}}i:9;a:7:{s:11:"category_id";i:1244;s:13:"category_name";s:7:"Tempere";s:17:"category_name_seo";s:7:"tempere";s:17:"category_name_aim";s:7:"Tempere";s:14:"category_image";s:19:"1244-1672858104.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:10;a:7:{s:11:"category_id";i:1245;s:13:"category_name";s:11:"Vodene boje";s:17:"category_name_seo";s:11:"vodene-boje";s:17:"category_name_aim";s:11:"Vodene boje";s:14:"category_image";s:19:"1245-1414507198.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:11;a:7:{s:11:"category_id";i:1247;s:13:"category_name";s:13:"Voštane boje";s:17:"category_name_seo";s:12:"vostane-boje";s:17:"category_name_aim";s:13:"Voštane boje";s:14:"category_image";s:19:"1247-1672858267.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}" ] |
||||||||||||||||||||||||||||||||||
| 21 | 0.27 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:
[
14
]
|
||||||||||||||||||||||||||||||||||
| 22 | 0.19 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:
[ 1790355623 "cache_tree_oidl_14" ] |
||||||||||||||||||||||||||||||||||
| 23 | 0.09 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.12 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:
[ 1790355623 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 25 | 0.08 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
]
|
||||||||||||||||||||||||||||||||||
| 26 | 0.08 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:
[ 1790355623 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 27 | 0.08 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:
[
14
]
|
||||||||||||||||||||||||||||||||||
| 28 | 0.06 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:
[ 1790355623 "cache_tree_oidl_14" ] |
||||||||||||||||||||||||||||||||||
| 29 | 0.05 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
]
|
||||||||||||||||||||||||||||||||||
| 30 | 0.07 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:
[ 1790355623 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 31 | 0.06 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
]
|
||||||||||||||||||||||||||||||||||
| 32 | 0.07 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:
[ 1790355623 "cache_tree_oidl_1" ] |
||||||||||||||||||||||||||||||||||
| 33 | 0.14 ms |
SELECT p.id id, p.product_id, p.name file_name, 1 file_type FROM proizvodi_pdf p WHERE p.active = 1 AND p.product_id = ? ORDER BY file_type
Parameters:
[
118556
]
|
||||||||||||||||||||||||||||||||||
| 34 | 0.08 ms |
SELECT p.share_link FROM proizvodi_filmovi p WHERE p.product_id = ? AND p.share_link != '' AND p.active = 1
Parameters:
[
118556
]
|
||||||||||||||||||||||||||||||||||
| 35 | 0.06 ms |
SELECT * FROM proizvodi_rejting_star WHERE product_id = ?
Parameters:
[
118556
]
|
||||||||||||||||||||||||||||||||||
| 36 | 0.08 ms |
SELECT * FROM proizvodi_komentari WHERE id_proizvoda = ? and active = 1 ORDER BY vreme DESC
Parameters:
[
118556
]
|
||||||||||||||||||||||||||||||||||
| 37 | 0.27 ms |
SELECT page_title, page_meta_description, page_meta_keywords, web_page FROM website_tags WHERE website = ? and web_page IN (?, ?)
Parameters:
[ 1 "proizvodi" "ostale" ]
|
||||||||||||||||||||||||||||||||||
| 38 | 0.23 ms |
SELECT k.category_name, k.category_name_seo, p.product_name, pl.id FROM kategorije k, proizvodi p, proizvodi_oprema pl WHERE p.id = pl.product_id AND p.id = ? AND pl.product_link_category_id = k.id AND p.active = 1 AND p.show_product = 1 AND k.active = 1 AND k.show_category = 1 ORDER BY pl.id
Parameters:
[
118556
]
|
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.