Query Metrics

38 Database Queries
12 Different statements
46.36 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ 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.