Query Metrics

57 Database Queries
17 Different statements
67.88 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.46 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:
[
  607
]
2 0.29 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:
[
  532
]
3 0.28 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:
[
  1790352558
  "cache_tree_oidl_532"
]
4 0.63 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:
[
  68
]
5 0.29 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:
[
  1790352558
  "cache_tree_oidl_68"
]
6 11.04 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352558
  "cache_tree_oidl_68"
]
7 0.79 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:
[
  68
  68
]
8 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:
[
  1199
  1199
]
9 0.50 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:
[
  995
  995
]
10 0.46 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:
[
  532
  532
]
11 0.44 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:
[
  1441
  1441
]
12 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:
[
  578
  578
]
13 0.41 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:
[
  999
  999
]
14 0.42 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:
[
  531
  531
]
15 0.41 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:
[
  950
  950
]
16 0.44 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:
[
  533
  533
]
17 14.84 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 => 1790352558
  0 => "cache_tree_oidl_68"
  1 => "a:2:{s:13:"subCategories";a:9:{i:0;a:7:{s:11:"category_id";i:1199;s:13:"category_name";s:31:"Noževi za kampovanje i prirodu";s:17:"category_name_seo";s:30:"nozevi-za-kampovanje-i-prirodu";s:17:"category_name_aim";s:31:"Noževi za kampovanje i prirodu";s:14:"category_image";s:19:"1199-1674907566.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"122603";s:10:"product_id";i:122603;s:4:"name";s:18:"Nož kamperski 5/1";s:12:"product_name";s:18:"Nož kamperski 5/1";s:3:"url";s:16:"noz-kamperski-51";s:4:"path";s:14:"/1/12/68/1199/";}i:1;a:6:{s:2:"id";s:6:"122493";s:10:"product_id";i:122493;s:4:"name";s:23:"Nož za pecaroše 100mm";s:12:"product_name";s:23:"Nož za pecaroše 100mm";s:3:"url";s:21:"noz-za-pecarose-100mm";s:4:"path";s:14:"/1/12/68/1199/";}i:2;a:6:{s:2:"id";s:6:"122341";s:10:"product_id";i:122341;s:4:"name";s:17:"Nož za pecaroše";s:12:"product_name";s:17:"Nož za pecaroše";s:3:"url";s:15:"noz-za-pecarose";s:4:"path";s:14:"/1/12/68/1199/";}i:3;a:6:{s:2:"id";s:6:"122037";s:10:"product_id";i:122037;s:4:"name";s:14:"Nož kamperski";s:12:"product_name";s:14:"Nož kamperski";s:3:"url";s:13:"noz-kamperski";s:4:"path";s:14:"/1/12/68/1199/";}i:4;a:6:{s:2:"id";s:6:"122016";s:10:"product_id";i:122016;s:4:"name";s:27:"Nož džepni više funkcija";s:12:"product_name";s:27:"Nož džepni više funkcija";s:3:"url";s:24:"noz-dzepni-vise-funkcija";s:4:"path";s:14:"/1/12/68/1199/";}}}i:1;a:7:{s:11:"category_id";i:995;s:13:"category_name";s:20:"Pumpe za naduvavanje";s:17:"category_name_seo";s:20:"pumpe-za-naduvavanje";s:17:"category_name_aim";s:20:"Pumpe za naduvavanje";s:14:"category_image";s:18:"995-1338214772.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"44424";s:10:"product_id";i:44424;s:4:"name";s:32:"Ručna pumpa za vazduh 14" Intex";s:12:"product_name";s:32:"Ručna pumpa za vazduh 14" Intex";s:3:"url";s:30:"rucna-pumpa-za-vazduh-14-intex";s:4:"path";s:13:"/1/12/68/995/";}i:1;a:6:{s:2:"id";s:5:"66077";s:10:"product_id";i:66077;s:4:"name";s:39:"Nožna pumpa za vazduh 28cm Intex 69611";s:12:"product_name";s:39:"Nožna pumpa za vazduh 28cm Intex 69611";s:3:"url";s:38:"nozna-pumpa-za-vazduh-28cm-intex-69611";s:4:"path";s:13:"/1/12/68/995/";}i:2;a:6:{s:2:"id";s:5:"72932";s:10:"product_id";i:72932;s:4:"name";s:34:"Pumpa DOUBLE QUICK III INTEX 68615";s:12:"product_name";s:34:"Pumpa DOUBLE QUICK III INTEX 68615";s:3:"url";s:34:"pumpa-double-quick-iii-intex-68615";s:4:"path";s:13:"/1/12/68/995/";}i:3;a:6:{s:2:"id";s:5:"34029";s:10:"product_id";i:34029;s:4:"name";s:43:"Pumpa nožna za duvanje  dušeka 5l Hausmax";s:12:"product_name";s:43:"Pumpa nožna za duvanje  dušeka 5l Hausmax";s:3:"url";s:40:"pumpa-nozna-za-duvanje-duseka-5l-hausmax";s:4:"path";s:13:"/1/12/68/995/";}i:4;a:6:{s:2:"id";s:6:"100407";s:10:"product_id";i:100407;s:4:"name";s:34:"Nožna pumpa za gume sa barometrom";s:12:"product_name";s:34:"Nožna pumpa za gume sa barometrom";s:3:"url";s:33:"nozna-pumpa-za-gume-sa-barometrom";s:4:"path";s:13:"/1/12/68/995/";}}}i:2;a:7:{s:11:"category_id";i:532;s:13:"category_name";s:24:"Rančevi za planinarenje";s:17:"category_name_seo";s:23:"rancevi-za-planinarenje";s:17:"category_name_aim";s:24:"Rančevi za planinarenje";s:14:"category_image";s:18:"532-1674908202.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:3;a:7:{s:11:"category_id";i:1441;s:13:"category_name";s:23:"Rashladne i termo torbe";s:17:"category_name_seo";s:23:"rashladne-i-termo-torbe";s:17:"category_name_aim";s:23:"Rashladne i termo torbe";s:14:"category_image";s:19:"1441-1661367884.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"122604";s:10:"product_id";i:122604;s:4:"name";s:23:"Termo torba 23x15x15 cm";s:12:"product_name";s:23:"Termo torba 23x15x15 cm";s:3:"url";s:23:"termo-torba-23x15x15-cm";s:4:"path";s:14:"/1/12/68/1441/";}i:1;a:6:{s:2:"id";s:6:"122447";s:10:"product_id";i:122447;s:4:"name";s:23:"Termo torba 48x17x38 cm";s:12:"product_name";s:23:"Termo torba 48x17x38 cm";s:3:"url";s:23:"termo-torba-48x17x38-cm";s:4:"path";s:14:"/1/12/68/1441/";}i:2;a:6:{s:2:"id";s:6:"105640";s:10:"product_id";i:105640;s:4:"name";s:23:"Rashladna torba 5.5 lit";s:12:"product_name";s:23:"Rashladna torba 5.5 lit";s:3:"url";s:22:"rashladna-torba-55-lit";s:4:"path";s:14:"/1/12/68/1441/";}i:3;a:6:{s:2:"id";s:6:"105639";s:10:"product_id";i:105639;s:4:"name";s:24:"Rashladna torba 11.7 lit";s:12:"product_name";s:24:"Rashladna torba 11.7 lit";s:3:"url";s:23:"rashladna-torba-117-lit";s:4:"path";s:14:"/1/12/68/1441/";}i:4;a:6:{s:2:"id";s:6:"105638";s:10:"product_id";i:105638;s:4:"name";s:19:"Rashladna torba 12L";s:12:"product_name";s:19:"Rashladna torba 12L";s:3:"url";s:19:"rashladna-torba-12l";s:4:"path";s:14:"/1/12/68/1441/";}}}i:4;a:7:{s:11:"category_id";i:578;s:13:"category_name";s:23:"Rekviziti za kampovanje";s:17:"category_name_seo";s:23:"rekviziti-za-kampovanje";s:17:"category_name_aim";s:23:"Rekviziti za kampovanje";s:14:"category_image";s:18:"578-1674909818.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:5:"95517";s:10:"product_id";i:95517;s:4:"name";s:39:"Ćebe za kampovanje i pinknik 200x150cm";s:12:"product_name";s:39:"Ćebe za kampovanje i pinknik 200x150cm";s:3:"url";s:38:"cebe-za-kampovanje-i-pinknik-200x150cm";s:4:"path";s:13:"/1/12/68/578/";}i:1;a:6:{s:2:"id";s:6:"112325";s:10:"product_id";i:112325;s:4:"name";s:43:"Sklopiva polica 55×55×90 cm za kampovanje";s:12:"product_name";s:43:"Sklopiva polica 55×55×90 cm za kampovanje";s:3:"url";s:39:"sklopiva-polica-555590-cm-za-kampovanje";s:4:"path";s:13:"/1/12/68/578/";}}}i:5;a:7:{s:11:"category_id";i:999;s:13:"category_name";s:17:"Ručni frižideri";s:17:"category_name_seo";s:15:"rucni-frizideri";s:17:"category_name_aim";s:17:"Ručni frižideri";s:14:"category_image";s:18:"999-1671910563.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"65923";s:10:"product_id";i:65923;s:4:"name";s:38:"Ručni prenosni frižider 10L - Curver";s:12:"product_name";s:38:"Ručni prenosni frižider 10L - Curver";s:3:"url";s:34:"rucni-prenosni-frizider-10l-curver";s:4:"path";s:14:"/1/29/368/999/";}i:1;a:6:{s:2:"id";s:5:"65924";s:10:"product_id";i:65924;s:4:"name";s:38:"Ručni prenosni frižider 20L - Curver";s:12:"product_name";s:38:"Ručni prenosni frižider 20L - Curver";s:3:"url";s:34:"rucni-prenosni-frizider-20l-curver";s:4:"path";s:14:"/1/29/368/999/";}i:2;a:6:{s:2:"id";s:5:"65925";s:10:"product_id";i:65925;s:4:"name";s:38:"Ručni prenosni frižider 32L - Curver";s:12:"product_name";s:38:"Ručni prenosni frižider 32L - Curver";s:3:"url";s:34:"rucni-prenosni-frizider-32l-curver";s:4:"path";s:14:"/1/29/368/999/";}i:3;a:6:{s:2:"id";s:6:"119282";s:10:"product_id";i:119282;s:4:"name";s:38:"Ručni frižider 23L – 12V, 45W HOME";s:12:"product_name";s:38:"Ručni frižider 23L – 12V, 45W HOME";s:3:"url";s:31:"rucni-frizider-23l-12v-45w-home";s:4:"path";s:14:"/1/29/368/999/";}i:4;a:6:{s:2:"id";s:5:"50472";s:10:"product_id";i:50472;s:4:"name";s:38:"Frižider za kola 24 L KB-7224 TRISTAR";s:12:"product_name";s:38:"Frižider za kola 24 L KB-7224 TRISTAR";s:3:"url";s:37:"frizider-za-kola-24-l-kb-7224-tristar";s:4:"path";s:14:"/1/29/368/999/";}}}i:6;a:7:{s:11:"category_id";i:531;s:13:"category_name";s:7:"Šatori";s:17:"category_name_seo";s:6:"satori";s:17:"category_name_aim";s:7:"Šatori";s:14:"category_image";s:18:"531-1673298500.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:4:{i:0;a:6:{s:2:"id";s:6:"111851";s:10:"product_id";i:111851;s:4:"name";s:37:"Pop up šator za plažu 220x120x100cm";s:12:"product_name";s:37:"Pop up šator za plažu 220x120x100cm";s:3:"url";s:35:"pop-up-sator-za-plazu-220x120x100cm";s:4:"path";s:13:"/1/12/68/531/";}i:1;a:6:{s:2:"id";s:6:"122789";s:10:"product_id";i:122789;s:4:"name";s:34:"Šator za kampovanje 200x140x105cm";s:12:"product_name";s:34:"Šator za kampovanje 200x140x105cm";s:3:"url";s:33:"sator-za-kampovanje-200x140x105cm";s:4:"path";s:13:"/1/12/68/531/";}i:2;a:6:{s:2:"id";s:6:"120843";s:10:"product_id";i:120843;s:4:"name";s:52:"Bestway šator za plažu  Quick 2, 200 x 120 x 90 cm";s:12:"product_name";s:52:"Bestway šator za plažu  Quick 2, 200 x 120 x 90 cm";s:3:"url";s:48:"bestway-sator-za-plazu-quick-2-200-x-120-x-90-cm";s:4:"path";s:13:"/1/12/68/531/";}i:3;a:6:{s:2:"id";s:5:"95488";s:10:"product_id";i:95488;s:4:"name";s:25:"Šator 200X200X120cm Haus";s:12:"product_name";s:25:"Šator 200X200X120cm Haus";s:3:"url";s:24:"sator-200x200x120cm-haus";s:4:"path";s:13:"/1/12/68/531/";}}}i:7;a:7:{s:11:"category_id";i:950;s:13:"category_name";s:17:"Vazdušni kreveti";s:17:"category_name_seo";s:16:"vazdusni-kreveti";s:17:"category_name_aim";s:17:"Vazdušni kreveti";s:14:"category_image";s:18:"950-1327760558.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"119865";s:10:"product_id";i:119865;s:4:"name";s:41:"Intex putni jastuk za vrat na naduvavanje";s:12:"product_name";s:41:"Intex putni jastuk za vrat na naduvavanje";s:3:"url";s:41:"intex-putni-jastuk-za-vrat-na-naduvavanje";s:4:"path";s:13:"/1/12/68/950/";}i:1;a:6:{s:2:"id";s:5:"77000";s:10:"product_id";i:77000;s:4:"name";s:65:"Krevet na naduvavanje Dura Beam Standard 76x191x25 cm INTEX 64756";s:12:"product_name";s:65:"Krevet na naduvavanje Dura Beam Standard 76x191x25 cm INTEX 64756";s:3:"url";s:65:"krevet-na-naduvavanje-dura-beam-standard-76x191x25-cm-intex-64756";s:4:"path";s:13:"/1/12/68/950/";}i:2;a:6:{s:2:"id";s:5:"77780";s:10:"product_id";i:77780;s:4:"name";s:48:"Vazdušni krevet VELOUR 137x191x25cm INTEX 64758";s:12:"product_name";s:48:"Vazdušni krevet VELOUR 137x191x25cm INTEX 64758";s:3:"url";s:47:"vazdusni-krevet-velour-137x191x25cm-intex-64758";s:4:"path";s:13:"/1/12/68/950/";}i:3;a:6:{s:2:"id";s:6:"100614";s:10:"product_id";i:100614;s:4:"name";s:31:"Vazdušni krevet-fotelja GL-750";s:12:"product_name";s:31:"Vazdušni krevet-fotelja GL-750";s:3:"url";s:30:"vazdusni-krevet-fotelja-gl-750";s:4:"path";s:13:"/1/12/68/950/";}i:4;a:6:{s:2:"id";s:6:"103678";s:10:"product_id";i:103678;s:4:"name";s:50:"Intex vazdušni krevet Dura beam 152 x 203 x 25 cm";s:12:"product_name";s:50:"Intex vazdušni krevet Dura beam 152 x 203 x 25 cm";s:3:"url";s:49:"intex-vazdusni-krevet-dura-beam-152-x-203-x-25-cm";s:4:"path";s:13:"/1/12/68/950/";}}}i:8;a:7:{s:11:"category_id";i:533;s:13:"category_name";s:18:"Vreće za spavanje";s:17:"category_name_seo";s:17:"vrece-za-spavanje";s:17:"category_name_aim";s:18:"Vreće za spavanje";s:14:"category_image";s:18:"533-1673654660.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:1:{i:0;a:6:{s:2:"id";s:5:"95529";s:10:"product_id";i:95529;s:4:"name";s:45:"Podloga za vreću za spavanje 190X60X3cm Haus";s:12:"product_name";s:45:"Podloga za vreću za spavanje 190X60X3cm Haus";s:3:"url";s:44:"podloga-za-vrecu-za-spavanje-190x60x3cm-haus";s:4:"path";s:13:"/1/12/68/533/";}}}}s:8:"products";a:0:{}}"
]
18 0.39 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:
[
  12
]
19 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:
[
  1790352558
  "cache_tree_oidl_12"
]
20 0.21 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
]
21 0.20 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:
[
  1790352558
  "cache_tree_oidl_1"
]
22 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
]
23 0.39 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:
[
  1790352558
  "cache_tree_oidl_1"
]
24 0.42 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:
[
  12
]
25 0.45 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:
[
  1790352558
  "cache_tree_oidl_12"
]
26 0.41 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
]
27 0.50 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:
[
  1790352558
  "cache_tree_oidl_1"
]
28 0.32 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
]
29 0.32 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:
[
  1790352558
  "cache_tree_oidl_1"
]
30 0.28 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:
[
  43181
]
31 0.21 ms
SELECT p.share_link
			FROM proizvodi_filmovi p
			WHERE p.product_id = ? AND p.share_link != '' AND p.active = 1
Parameters:
[
  43181
]
32 0.16 ms
SELECT * 
			FROM proizvodi_rejting_star 
			WHERE product_id = ?
Parameters:
[
  43181
]
33 0.26 ms
SELECT *
			FROM proizvodi_komentari
			WHERE id_proizvoda = ? and active = 1
			ORDER BY vreme DESC
Parameters:
[
  43181
]
34 0.38 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"
]
35 0.43 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:
[
  43181
]
36 0.46 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:
[
  532
]
37 0.26 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:
[
  1790352558
  "cache_tree_oidl_532"
]
38 0.31 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:
[
  68
]
39 0.28 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:
[
  1790352558
  "cache_tree_oidl_68"
]
40 0.25 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:
[
  12
]
41 0.27 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:
[
  1790352558
  "cache_tree_oidl_12"
]
42 0.24 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
]
43 0.33 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:
[
  1790352558
  "cache_tree_oidl_1"
]
44 0.26 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
]
45 0.28 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:
[
  1790352558
  "cache_tree_oidl_1"
]
46 0.32 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:
[
  12
]
47 0.31 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:
[
  1790352558
  "cache_tree_oidl_12"
]
48 0.24 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
]
49 0.26 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:
[
  1790352558
  "cache_tree_oidl_1"
]
50 0.23 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
]
51 0.20 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:
[
  1790352558
  "cache_tree_oidl_1"
]
52 0.73 ms
SELECT COUNT(p.id) broj_proizvoda, b.id AS brand_id, b.brand_name, brand_image
			FROM proizvodi p, proizvodjaci b
			WHERE p.brand_id = b.id
			AND p.active = 1 AND p.show_product=1 AND b.active = 1 AND b.show_brand = 1
			AND (p.copy_from_id is NULL OR p.copy_from_id = '') AND p.category_id = ?
			GROUP BY p.brand_id
			ORDER BY b.brand_name
Parameters:
[
  532
]
53 0.29 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:
[
  1790352558
  "cache_tree_oidl_1"
]
54 1.24 ms
SELECT b.id AS brand_id, b.brand_name, b.num_of_products AS broj_proizvoda
			FROM proizvodjaci b
			WHERE b.active = 1 AND b.show_brand = 1
			ORDER BY broj_proizvoda DESC
			LIMIT 25
Parameters:
[]
55 21.98 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
56 0.71 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products > 0
Parameters:
[]
57 0.11 ms
SELECT * FROM upload_images ORDER BY id
Parameters:
[]

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.