GET https://dev.alatiimasine.com/proizvod/zvucne-kutije-40w-microlab/

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 0.27 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:
[
  1037
]
2 0.16 ms
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, 
	        	       `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated,
	        	       show_eponuda
	        	FROM kategorije 
	        	WHERE id = ? and active = 1
Parameters:
[
  774
]
3 7.53 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:
[
  1790352416
  "cache_tree_oidl_774"
]
4 17.82 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352416
  "cache_tree_oidl_774"
]
5 0.38 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:
[
  774
  774
]
6 14.11 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 => 1790352416
  0 => "cache_tree_oidl_774"
  1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"64057";s:10:"product_id";i:64057;s:4:"name";s:30:"Šolja za zvučnu kutiju HT901";s:12:"product_name";s:30:"Šolja za zvučnu kutiju HT901";s:3:"url";s:28:"solja-za-zvucnu-kutiju-ht901";s:4:"path";s:15:"/1/169/772/774/";}i:1;a:6:{s:2:"id";s:5:"95159";s:10:"product_id";i:95159;s:4:"name";s:33:"Mini multimedijalni zvučnici SAL";s:12:"product_name";s:33:"Mini multimedijalni zvučnici SAL";s:3:"url";s:32:"mini-multimedijalni-zvucnici-sal";s:4:"path";s:15:"/1/169/772/774/";}i:2;a:6:{s:2:"id";s:5:"86453";s:10:"product_id";i:86453;s:4:"name";s:42:"Razglasni 110V zvučnik - nazidni WAS2 SAL";s:12:"product_name";s:42:"Razglasni 110V zvučnik - nazidni WAS2 SAL";s:3:"url";s:39:"razglasni-110v-zvucnik-nazidni-was2-sal";s:4:"path";s:15:"/1/169/772/774/";}i:3;a:6:{s:2:"id";s:5:"88762";s:10:"product_id";i:88762;s:4:"name";s:35:"SAL Pasivna zvučna kutija BXB100/8";s:12:"product_name";s:35:"SAL Pasivna zvučna kutija BXB100/8";s:3:"url";s:33:"sal-pasivna-zvucna-kutija-bxb1008";s:4:"path";s:15:"/1/169/772/774/";}i:4;a:6:{s:2:"id";s:5:"96588";s:10:"product_id";i:96588;s:4:"name";s:47:"Aktivni zvučnici sa BT konekcijom 42W MICROLAB";s:12:"product_name";s:47:"Aktivni zvučnici sa BT konekcijom 42W MICROLAB";s:3:"url";s:46:"aktivni-zvucnici-sa-bt-konekcijom-42w-microlab";s:4:"path";s:15:"/1/169/772/774/";}}}"
]
7 2.38 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:
[
  772
]
8 0.10 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:
[
  1790352416
  "cache_tree_oidl_772"
]
9 22.84 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352416
  "cache_tree_oidl_772"
]
10 0.31 ms
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image
	        FROM kategorije k 
	        WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1
	        UNION ALL 
	        (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image
	        FROM kategorije_veze c1, kategorije c2 
	        WHERE c1.category_id = c2.id and c1.parent_category_id = ?  and c1.active = 1 and c2.show_category = 1) 
	        ORDER BY category_name
Parameters:
[
  772
  772
]
11 0.16 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:
[
  1380
  1380
]
12 0.28 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:
[
  1379
  1379
]
13 0.17 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:
[
  774
  774
]
14 0.15 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:
[
  773
  773
]
15 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:
[
  383
  383
]
16 0.33 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:
[
  273
  273
]
17 8.86 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 => 1790352416
  0 => "cache_tree_oidl_772"
  1 => "a:2:{s:13:"subCategories";a:6:{i:0;a:7:{s:11:"category_id";i:1380;s:13:"category_name";s:19:"Bluetooth zvučnici";s:17:"category_name_seo";s:18:"bluetooth-zvucnici";s:17:"category_name_aim";s:19:"Bluetooth zvučnici";s:14:"category_image";s:19:"1380-1675163355.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"90766";s:10:"product_id";i:90766;s:4:"name";s:36:"Metalni bluetooth zvučnik crni ZOLT";s:12:"product_name";s:36:"Metalni bluetooth zvučnik crni ZOLT";s:3:"url";s:35:"metalni-bluetooth-zvucnik-crni-zolt";s:4:"path";s:16:"/1/169/894/1380/";}i:1;a:6:{s:2:"id";s:5:"83730";s:10:"product_id";i:83730;s:4:"name";s:34:"Bluetooth zvučnik od bambusa Luca";s:12:"product_name";s:34:"Bluetooth zvučnik od bambusa Luca";s:3:"url";s:33:"bluetooth-zvucnik-od-bambusa-luca";s:4:"path";s:16:"/1/169/894/1380/";}i:2;a:6:{s:2:"id";s:5:"90076";s:10:"product_id";i:90076;s:4:"name";s:37:"Metalni bluetooth zvučnik crni TURNO";s:12:"product_name";s:37:"Metalni bluetooth zvučnik crni TURNO";s:3:"url";s:36:"metalni-bluetooth-zvucnik-crni-turno";s:4:"path";s:16:"/1/169/894/1380/";}i:3;a:6:{s:2:"id";s:5:"90080";s:10:"product_id";i:90080;s:4:"name";s:39:"Metalni bluetooth zvučnik crveni TURNO";s:12:"product_name";s:39:"Metalni bluetooth zvučnik crveni TURNO";s:3:"url";s:38:"metalni-bluetooth-zvucnik-crveni-turno";s:4:"path";s:16:"/1/169/894/1380/";}i:4;a:6:{s:2:"id";s:5:"90081";s:10:"product_id";i:90081;s:4:"name";s:40:"Metalni bluetooth zvučnik srebrni TURNO";s:12:"product_name";s:40:"Metalni bluetooth zvučnik srebrni TURNO";s:3:"url";s:39:"metalni-bluetooth-zvucnik-srebrni-turno";s:4:"path";s:16:"/1/169/894/1380/";}}}i:1;a:7:{s:11:"category_id";i:1379;s:13:"category_name";s:31:"Prenosne karaoke zvučne kutije";s:17:"category_name_seo";s:30:"prenosne-karaoke-zvucne-kutije";s:17:"category_name_aim";s:31:"Prenosne karaoke zvučne kutije";s:14:"category_image";s:19:"1379-1567514864.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"83939";s:10:"product_id";i:83939;s:4:"name";s:49:"Bluetooth karaoke prenosni zvučnik XP8803 XPLORE";s:12:"product_name";s:49:"Bluetooth karaoke prenosni zvučnik XP8803 XPLORE";s:3:"url";s:48:"bluetooth-karaoke-prenosni-zvucnik-xp8803-xplore";s:4:"path";s:16:"/1/169/772/1379/";}i:1;a:6:{s:2:"id";s:5:"75510";s:10:"product_id";i:75510;s:4:"name";s:66:"Prenosivi zvučnik sa Li-Jon baterijom 250 W XP8800 Pascha2 Xplore";s:12:"product_name";s:66:"Prenosivi zvučnik sa Li-Jon baterijom 250 W XP8800 Pascha2 Xplore";s:3:"url";s:65:"prenosivi-zvucnik-sa-li-jon-baterijom-250-w-xp8800-pascha2-xplore";s:4:"path";s:16:"/1/169/772/1379/";}i:2;a:6:{s:2:"id";s:5:"83943";s:10:"product_id";i:83943;s:4:"name";s:49:"Bluetooth karaoke prenosni zvučnik XP8804 XPLORE";s:12:"product_name";s:49:"Bluetooth karaoke prenosni zvučnik XP8804 XPLORE";s:3:"url";s:48:"bluetooth-karaoke-prenosni-zvucnik-xp8804-xplore";s:4:"path";s:16:"/1/169/772/1379/";}i:3;a:6:{s:2:"id";s:5:"75511";s:10:"product_id";i:75511;s:4:"name";s:60:"Prenosivi zvučnik sa mikrofonima 300 W XP8802 Cabana Xplore";s:12:"product_name";s:60:"Prenosivi zvučnik sa mikrofonima 300 W XP8802 Cabana Xplore";s:3:"url";s:59:"prenosivi-zvucnik-sa-mikrofonima-300-w-xp8802-cabana-xplore";s:4:"path";s:16:"/1/169/772/1379/";}i:4;a:6:{s:2:"id";s:5:"75492";s:10:"product_id";i:75492;s:4:"name";s:71:"Mobilni zvučnik sa akumulatorom i mikrofonom 150W XP8807 Shoore Xplore";s:12:"product_name";s:71:"Mobilni zvučnik sa akumulatorom i mikrofonom 150W XP8807 Shoore Xplore";s:3:"url";s:70:"mobilni-zvucnik-sa-akumulatorom-i-mikrofonom-150w-xp8807-shoore-xplore";s:4:"path";s:16:"/1/169/772/1379/";}}}i:2;a:7:{s:11:"category_id";i:774;s:13:"category_name";s:14:"Zvučne kutije";s:17:"category_name_seo";s:13:"zvucne-kutije";s:17:"category_name_aim";s:14:"Zvučne kutije";s:14:"category_image";s:18:"774-1675167821.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"64057";s:10:"product_id";i:64057;s:4:"name";s:30:"Šolja za zvučnu kutiju HT901";s:12:"product_name";s:30:"Šolja za zvučnu kutiju HT901";s:3:"url";s:28:"solja-za-zvucnu-kutiju-ht901";s:4:"path";s:15:"/1/169/772/774/";}i:1;a:6:{s:2:"id";s:5:"95159";s:10:"product_id";i:95159;s:4:"name";s:33:"Mini multimedijalni zvučnici SAL";s:12:"product_name";s:33:"Mini multimedijalni zvučnici SAL";s:3:"url";s:32:"mini-multimedijalni-zvucnici-sal";s:4:"path";s:15:"/1/169/772/774/";}i:2;a:6:{s:2:"id";s:5:"86453";s:10:"product_id";i:86453;s:4:"name";s:42:"Razglasni 110V zvučnik - nazidni WAS2 SAL";s:12:"product_name";s:42:"Razglasni 110V zvučnik - nazidni WAS2 SAL";s:3:"url";s:39:"razglasni-110v-zvucnik-nazidni-was2-sal";s:4:"path";s:15:"/1/169/772/774/";}i:3;a:6:{s:2:"id";s:5:"88762";s:10:"product_id";i:88762;s:4:"name";s:35:"SAL Pasivna zvučna kutija BXB100/8";s:12:"product_name";s:35:"SAL Pasivna zvučna kutija BXB100/8";s:3:"url";s:33:"sal-pasivna-zvucna-kutija-bxb1008";s:4:"path";s:15:"/1/169/772/774/";}i:4;a:6:{s:2:"id";s:5:"96588";s:10:"product_id";i:96588;s:4:"name";s:47:"Aktivni zvučnici sa BT konekcijom 42W MICROLAB";s:12:"product_name";s:47:"Aktivni zvučnici sa BT konekcijom 42W MICROLAB";s:3:"url";s:46:"aktivni-zvucnici-sa-bt-konekcijom-42w-microlab";s:4:"path";s:15:"/1/169/772/774/";}}}i:3;a:7:{s:11:"category_id";i:773;s:13:"category_name";s:17:"Zvučnici ugradni";s:17:"category_name_seo";s:16:"zvucnici-ugradni";s:17:"category_name_aim";s:17:"Zvučnici ugradni";s:14:"category_image";s:18:"773-1675167799.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:6:"118055";s:10:"product_id";i:118055;s:4:"name";s:39:"Niskotonski zvučnik 300mm 210W SPA3040";s:12:"product_name";s:39:"Niskotonski zvučnik 300mm 210W SPA3040";s:3:"url";s:38:"niskotonski-zvucnik-300mm-210w-spa3040";s:4:"path";s:15:"/1/169/772/773/";}i:1;a:6:{s:2:"id";s:6:"117834";s:10:"product_id";i:117834;s:4:"name";s:39:"Niskotonski zvučnik 400mm 230W SPA4050";s:12:"product_name";s:39:"Niskotonski zvučnik 400mm 230W SPA4050";s:3:"url";s:38:"niskotonski-zvucnik-400mm-230w-spa4050";s:4:"path";s:15:"/1/169/772/773/";}}}i:4;a:7:{s:11:"category_id";i:383;s:13:"category_name";s:17:"Zvučnici za kola";s:17:"category_name_seo";s:16:"zvucnici-za-kola";s:17:"category_name_aim";s:17:"Zvučnici za kola";s:14:"category_image";s:18:"383-1675073224.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"57196";s:10:"product_id";i:57196;s:4:"name";s:41:"Piezo visokotonski zvučnik 38mm 80W AP17";s:12:"product_name";s:41:"Piezo visokotonski zvučnik 38mm 80W AP17";s:3:"url";s:40:"piezo-visokotonski-zvucnik-38mm-80w-ap17";s:4:"path";s:15:"/1/169/382/383/";}i:1;a:6:{s:2:"id";s:5:"50144";s:10:"product_id";i:50144;s:4:"name";s:36:"Auto zvučnici 100mm 2x45W BK100 SAL";s:12:"product_name";s:36:"Auto zvučnici 100mm 2x45W BK100 SAL";s:3:"url";s:35:"auto-zvucnici-100mm-2x45w-bk100-sal";s:4:"path";s:15:"/1/169/382/383/";}i:2;a:6:{s:2:"id";s:5:"50151";s:10:"product_id";i:50151;s:4:"name";s:32:"Auto zvučnici 130mm 2x50W BK130";s:12:"product_name";s:32:"Auto zvučnici 130mm 2x50W BK130";s:3:"url";s:31:"auto-zvucnici-130mm-2x50w-bk130";s:4:"path";s:15:"/1/169/382/383/";}i:3;a:6:{s:2:"id";s:5:"50156";s:10:"product_id";i:50156;s:4:"name";s:32:"Auto zvučnici 165mm 2x75W BK165";s:12:"product_name";s:32:"Auto zvučnici 165mm 2x75W BK165";s:3:"url";s:31:"auto-zvucnici-165mm-2x75w-bk165";s:4:"path";s:15:"/1/169/382/383/";}i:4;a:6:{s:2:"id";s:5:"57192";s:10:"product_id";i:57192;s:4:"name";s:45:"Auto zvučnici dvosistemski 100mm 2x55W CX404";s:12:"product_name";s:45:"Auto zvučnici dvosistemski 100mm 2x55W CX404";s:3:"url";s:44:"auto-zvucnici-dvosistemski-100mm-2x55w-cx404";s:4:"path";s:15:"/1/169/382/383/";}}}i:5;a:7:{s:11:"category_id";i:273;s:13:"category_name";s:22:"Zvučnici za računare";s:17:"category_name_seo";s:20:"zvucnici-za-racunare";s:17:"category_name_aim";s:22:"Zvučnici za računare";s:14:"category_image";s:18:"273-1675167840.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"115296";s:10:"product_id";i:115296;s:4:"name";s:44:"Esperanza EP111 stereo zvučnik 2.0 leggiero";s:12:"product_name";s:44:"Esperanza EP111 stereo zvučnik 2.0 leggiero";s:3:"url";s:42:"esperanza-ep111-stereo-zvucnik-20-leggiero";s:4:"path";s:15:"/1/172/205/273/";}i:1;a:6:{s:2:"id";s:6:"115295";s:10:"product_id";i:115295;s:4:"name";s:43:"Esperanza EP110 stereo zvučnik 2.0 giocoso";s:12:"product_name";s:43:"Esperanza EP110 stereo zvučnik 2.0 giocoso";s:3:"url";s:41:"esperanza-ep110-stereo-zvucnik-20-giocoso";s:4:"path";s:15:"/1/172/205/273/";}i:2;a:6:{s:2:"id";s:5:"89758";s:10:"product_id";i:89758;s:4:"name";s:33:"ESPERANZA Zvučnici 2.0 USB EP152";s:12:"product_name";s:33:"ESPERANZA Zvučnici 2.0 USB EP152";s:3:"url";s:31:"esperanza-zvucnici-20-usb-ep152";s:4:"path";s:15:"/1/172/205/273/";}i:3;a:6:{s:2:"id";s:5:"69614";s:10:"product_id";i:69614;s:4:"name";s:36:"Zvučnici USB 2.1 Stereo SP4000 SBox";s:12:"product_name";s:36:"Zvučnici USB 2.1 Stereo SP4000 SBox";s:3:"url";s:34:"zvucnici-usb-21-stereo-sp4000-sbox";s:4:"path";s:15:"/1/172/205/273/";}i:4;a:6:{s:2:"id";s:5:"23551";s:10:"product_id";i:23551;s:4:"name";s:27:"Zvučnici Z313 2.1 LOGITECH";s:12:"product_name";s:27:"Zvučnici Z313 2.1 LOGITECH";s:3:"url";s:25:"zvucnici-z313-21-logitech";s:4:"path";s:15:"/1/172/205/273/";}}}}s:8:"products";a:0:{}}"
]
18 0.19 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:
[
  169
]
19 0.11 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:
[
  1790352416
  "cache_tree_oidl_169"
]
20 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
]
21 0.10 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:
[
  1790352416
  "cache_tree_oidl_1"
]
22 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
]
23 0.16 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:
[
  1790352416
  "cache_tree_oidl_1"
]
24 0.15 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:
[
  169
]
25 0.09 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:
[
  1790352416
  "cache_tree_oidl_169"
]
26 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
]
27 0.09 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:
[
  1790352416
  "cache_tree_oidl_1"
]
28 0.14 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.10 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:
[
  1790352416
  "cache_tree_oidl_1"
]
30 0.12 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:
[
  96589
]
31 0.10 ms
SELECT p.share_link
			FROM proizvodi_filmovi p
			WHERE p.product_id = ? AND p.share_link != '' AND p.active = 1
Parameters:
[
  96589
]
32 0.08 ms
SELECT * 
			FROM proizvodi_rejting_star 
			WHERE product_id = ?
Parameters:
[
  96589
]
33 0.10 ms
SELECT *
			FROM proizvodi_komentari
			WHERE id_proizvoda = ? and active = 1
			ORDER BY vreme DESC
Parameters:
[
  96589
]
34 0.28 ms
SELECT page_title, page_meta_description, page_meta_keywords, web_page
	        FROM website_tags
	        WHERE website = ? and web_page IN (?, ?)
Parameters:
[
  1
  "proizvodi"
  "ostale"
]
35 0.21 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:
[
  96589
]
36 0.17 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:
[
  774
]
37 0.10 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:
[
  1790352416
  "cache_tree_oidl_774"
]
38 0.10 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:
[
  772
]
39 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:
[
  1790352416
  "cache_tree_oidl_772"
]
40 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:
[
  169
]
41 0.09 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:
[
  1790352416
  "cache_tree_oidl_169"
]
42 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
]
43 0.11 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:
[
  1790352416
  "cache_tree_oidl_1"
]
44 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
]
45 0.09 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:
[
  1790352416
  "cache_tree_oidl_1"
]
46 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:
[
  169
]
47 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:
[
  1790352416
  "cache_tree_oidl_169"
]
48 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
]
49 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:
[
  1790352416
  "cache_tree_oidl_1"
]
50 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
]
51 0.09 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:
[
  1790352416
  "cache_tree_oidl_1"
]
52 0.69 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:
[
  774
]
53 0.13 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:
[
  1790352416
  "cache_tree_oidl_1"
]
54 0.66 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 18.20 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
56 0.46 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products > 0
Parameters:
[]
57 0.14 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.