Query Metrics

58 Database Queries
17 Different statements
64.12 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.14 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.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:
[
  611
]
3 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:
[
  1790352394
  "cache_tree_oidl_611"
]
4 8.91 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352394
  "cache_tree_oidl_611"
]
5 0.24 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:
[
  611
  611
]
6 7.95 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 => 1790352394
  0 => "cache_tree_oidl_611"
  1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"115718";s:10:"product_id";i:115718;s:4:"name";s:25:"Hama notebook cooler Wave";s:12:"product_name";s:25:"Hama notebook cooler Wave";s:3:"url";s:25:"hama-notebook-cooler-wave";s:4:"path";s:15:"/1/172/606/611/";}i:1;a:6:{s:2:"id";s:5:"29256";s:10:"product_id";i:29256;s:4:"name";s:42:"USB mini ventilator za notebook 49139 Hama";s:12:"product_name";s:42:"USB mini ventilator za notebook 49139 Hama";s:3:"url";s:42:"usb-mini-ventilator-za-notebook-49139-hama";s:4:"path";s:15:"/1/172/606/611/";}i:2;a:6:{s:2:"id";s:5:"69609";s:10:"product_id";i:69609;s:4:"name";s:48:"Postolje za hladjenje laptopova CP-12 17,3" SBox";s:12:"product_name";s:48:"Postolje za hladjenje laptopova CP-12 17,3" SBox";s:3:"url";s:46:"postolje-za-hladjenje-laptopova-cp-12-173-sbox";s:4:"path";s:15:"/1/172/606/611/";}i:3;a:6:{s:2:"id";s:5:"69608";s:10:"product_id";i:69608;s:4:"name";s:47:"USB Cooling pad za laptop računare CP-101 SBOX";s:12:"product_name";s:47:"USB Cooling pad za laptop računare CP-101 SBOX";s:3:"url";s:46:"usb-cooling-pad-za-laptop-racunare-cp-101-sbox";s:4:"path";s:15:"/1/172/606/611/";}i:4;a:6:{s:2:"id";s:6:"120193";s:10:"product_id";i:120193;s:4:"name";s:60:"Stalak za laptop prenosivi Alumia Fellowes 100138867 srebrni";s:12:"product_name";s:60:"Stalak za laptop prenosivi Alumia Fellowes 100138867 srebrni";s:3:"url";s:60:"stalak-za-laptop-prenosivi-alumia-fellowes-100138867-srebrni";s:4:"path";s:15:"/1/172/606/611/";}}}"
]
7 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:
[
  606
]
8 0.14 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:
[
  1790352394
  "cache_tree_oidl_606"
]
9 8.35 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352394
  "cache_tree_oidl_606"
]
10 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:
[
  606
  606
]
11 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:
[
  613
  613
]
12 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:
[
  610
  610
]
13 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:
[
  607
  607
]
14 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:
[
  608
  608
]
15 0.23 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:
[
  609
  609
]
16 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:
[
  612
  612
]
17 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:
[
  611
  611
]
18 10.74 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 => 1790352394
  0 => "cache_tree_oidl_606"
  1 => "a:2:{s:13:"subCategories";a:7:{i:0;a:7:{s:11:"category_id";i:613;s:13:"category_name";s:19:"Držači dokumenata";s:17:"category_name_seo";s:17:"drzaci-dokumenata";s:17:"category_name_aim";s:19:"Držači dokumenata";s:14:"category_image";s:18:"613-1675020420.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:1:{i:0;a:6:{s:2:"id";s:5:"52565";s:10:"product_id";i:52565;s:4:"name";s:61:"Podloga klip s preklopom+gumica A4 pp Exaboard EXACOMPTA crna";s:12:"product_name";s:61:"Podloga klip s preklopom+gumica A4 pp Exaboard EXACOMPTA crna";s:3:"url";s:60:"podloga-klip-s-preklopomgumica-a4-pp-exaboard-exacompta-crna";s:4:"path";s:15:"/1/172/606/613/";}}}i:1;a:7:{s:11:"category_id";i:610;s:13:"category_name";s:20:"Držači za monitore";s:17:"category_name_seo";s:18:"drzaci-za-monitore";s:17:"category_name_aim";s:20:"Držači za monitore";s:14:"category_image";s:18:"610-1298670120.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"16759";s:10:"product_id";i:16759;s:4:"name";s:65:"Držač monitora/postolje-Fellowes Standard Monitor Riser-Graphit";s:12:"product_name";s:65:"Držač monitora/postolje-Fellowes Standard Monitor Riser-Graphit";s:3:"url";s:62:"drzac-monitorapostolje-fellowes-standard-monitor-riser-graphit";s:4:"path";s:15:"/1/172/606/610/";}i:1;a:6:{s:2:"id";s:6:"118542";s:10:"product_id";i:118542;s:4:"name";s:67:"Stalak za laptop prenosivi Alumia Fellowes 100138868 crni 000021532";s:12:"product_name";s:67:"Stalak za laptop prenosivi Alumia Fellowes 100138868 crni 000021532";s:3:"url";s:67:"stalak-za-laptop-prenosivi-alumia-fellowes-100138868-crni-000021532";s:4:"path";s:15:"/1/172/606/610/";}i:2;a:6:{s:2:"id";s:6:"114641";s:10:"product_id";i:114641;s:4:"name";s:46:"Stoni nosač za dva monitora 17" do 32" Prosto";s:12:"product_name";s:46:"Stoni nosač za dva monitora 17" do 32" Prosto";s:3:"url";s:43:"stoni-nosac-za-dva-monitora-17-do-32-prosto";s:4:"path";s:15:"/1/172/606/610/";}i:3;a:6:{s:2:"id";s:6:"118481";s:10:"product_id";i:118481;s:4:"name";s:65:"Stalak za monitor Designer Suites Fellowes 8038101 crni 000019480";s:12:"product_name";s:65:"Stalak za monitor Designer Suites Fellowes 8038101 crni 000019480";s:3:"url";s:65:"stalak-za-monitor-designer-suites-fellowes-8038101-crni-000019480";s:4:"path";s:15:"/1/172/606/610/";}i:4;a:6:{s:2:"id";s:6:"114443";s:10:"product_id";i:114443;s:4:"name";s:91:"Gembird Podesivi stoni držač za monitor sa 4 ruke, tilt rotacija okretanje,13-32 max 10kg";s:12:"product_name";s:91:"Gembird Podesivi stoni držač za monitor sa 4 ruke, tilt rotacija okretanje,13-32 max 10kg";s:3:"url";s:87:"gembird-podesivi-stoni-drzac-za-monitor-sa-4-ruke-tilt-rotacija-okretanje13-32-max-10kg";s:4:"path";s:15:"/1/172/606/610/";}}}i:2;a:7:{s:11:"category_id";i:607;s:13:"category_name";s:15:"Odmarač zgloba";s:17:"category_name_seo";s:14:"odmarac-zgloba";s:17:"category_name_aim";s:15:"Odmarač zgloba";s:14:"category_image";s:18:"607-1675020754.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:4:{i:0;a:6:{s:2:"id";s:5:"16552";s:10:"product_id";i:16552;s:4:"name";s:42:"Odmarač zgloba Crystals Gel-crna-Fellowes";s:12:"product_name";s:42:"Odmarač zgloba Crystals Gel-crna-Fellowes";s:3:"url";s:41:"odmarac-zgloba-crystals-gel-crna-fellowes";s:4:"path";s:15:"/1/172/606/607/";}i:1;a:6:{s:2:"id";s:5:"16556";s:10:"product_id";i:16556;s:4:"name";s:65:"Podloga za miša sa odmaračem zgloba Crystals Gel-plava-Fellowes";s:12:"product_name";s:65:"Podloga za miša sa odmaračem zgloba Crystals Gel-plava-Fellowes";s:3:"url";s:63:"podloga-za-misa-sa-odmaracem-zgloba-crystals-gel-plava-fellowes";s:4:"path";s:15:"/1/172/606/607/";}i:2;a:6:{s:2:"id";s:5:"16555";s:10:"product_id";i:16555;s:4:"name";s:64:"Podloga za miša sa odmaračem zgloba Crystals Gel-crna-Fellowes";s:12:"product_name";s:64:"Podloga za miša sa odmaračem zgloba Crystals Gel-crna-Fellowes";s:3:"url";s:62:"podloga-za-misa-sa-odmaracem-zgloba-crystals-gel-crna-fellowes";s:4:"path";s:15:"/1/172/606/607/";}i:3;a:6:{s:2:"id";s:5:"16557";s:10:"product_id";i:16557;s:4:"name";s:71:"Podloga za miša sa odmaračem zgloba Crystals Gel-ljubičasta-Fellowes";s:12:"product_name";s:71:"Podloga za miša sa odmaračem zgloba Crystals Gel-ljubičasta-Fellowes";s:3:"url";s:68:"podloga-za-misa-sa-odmaracem-zgloba-crystals-gel-ljubicasta-fellowes";s:4:"path";s:15:"/1/172/606/607/";}}}i:3;a:7:{s:11:"category_id";i:608;s:13:"category_name";s:18:"Odmarači za leđa";s:17:"category_name_seo";s:16:"odmaraci-za-leda";s:17:"category_name_aim";s:18:"Odmarači za leđa";s:14:"category_image";s:18:"608-1298669774.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"118942";s:10:"product_id";i:118942;s:4:"name";s:72:"Odmarač za leđa-jastuk Lumbar Breyta Fellowes 100119853 crni 000021417";s:12:"product_name";s:72:"Odmarač za leđa-jastuk Lumbar Breyta Fellowes 100119853 crni 000021417";s:3:"url";s:70:"odmarac-za-leda-jastuk-lumbar-breyta-fellowes-100119853-crni-000021417";s:4:"path";s:15:"/1/172/606/608/";}i:1;a:6:{s:2:"id";s:6:"118415";s:10:"product_id";i:118415;s:4:"name";s:50:"Odmarač za leđa Plushtouch Fellowes 8026501 crni";s:12:"product_name";s:50:"Odmarač za leđa Plushtouch Fellowes 8026501 crni";s:3:"url";s:48:"odmarac-za-leda-plushtouch-fellowes-8026501-crni";s:4:"path";s:15:"/1/172/606/608/";}i:2;a:6:{s:2:"id";s:6:"118233";s:10:"product_id";i:118233;s:4:"name";s:63:"Odmarač za leđa-jastuk Comfort Breyta Fellowes 100119852 crni";s:12:"product_name";s:63:"Odmarač za leđa-jastuk Comfort Breyta Fellowes 100119852 crni";s:3:"url";s:61:"odmarac-za-leda-jastuk-comfort-breyta-fellowes-100119852-crni";s:4:"path";s:15:"/1/172/606/608/";}i:3;a:6:{s:2:"id";s:5:"16642";s:10:"product_id";i:16642;s:4:"name";s:65:"Odmarač leđa za kancelarijsku stolicu Office Mesh Back Fellowes";s:12:"product_name";s:65:"Odmarač leđa za kancelarijsku stolicu Office Mesh Back Fellowes";s:3:"url";s:63:"odmarac-leda-za-kancelarijsku-stolicu-office-mesh-back-fellowes";s:4:"path";s:15:"/1/172/606/608/";}i:4;a:6:{s:2:"id";s:5:"92349";s:10:"product_id";i:92349;s:4:"name";s:57:"Fellowes Odmarač za leđa Mesh Professional 8029901 crni";s:12:"product_name";s:57:"Fellowes Odmarač za leđa Mesh Professional 8029901 crni";s:3:"url";s:54:"fellowes-odmarac-za-leda-mesh-profesional-8029901-crni";s:4:"path";s:15:"/1/172/606/608/";}}}i:4;a:7:{s:11:"category_id";i:609;s:13:"category_name";s:17:"Odmarači za noge";s:17:"category_name_seo";s:16:"odmaraci-za-noge";s:17:"category_name_aim";s:17:"Odmarači za noge";s:14:"category_image";s:18:"609-1298669847.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"16690";s:10:"product_id";i:16690;s:4:"name";s:40:"Odmarač nogu-Fellowes Standard Footrest";s:12:"product_name";s:40:"Odmarač nogu-Fellowes Standard Footrest";s:3:"url";s:39:"odmarac-nogu-fellowes-standard-footrest";s:4:"path";s:15:"/1/172/606/609/";}i:1;a:6:{s:2:"id";s:5:"84082";s:10:"product_id";i:84082;s:4:"name";s:30:"Odmarač nogu Refresh Fellowes";s:12:"product_name";s:30:"Odmarač nogu Refresh Fellowes";s:3:"url";s:29:"odmarac-nogu-refresh-fellowes";s:4:"path";s:15:"/1/172/606/609/";}i:2;a:6:{s:2:"id";s:6:"118932";s:10:"product_id";i:118932;s:4:"name";s:54:"Odmarač nogu Breyta Fellowes 100016562 crna 000020664";s:12:"product_name";s:54:"Odmarač nogu Breyta Fellowes 100016562 crna 000020664";s:3:"url";s:53:"odmarac-nogu-breyta-fellowes-100016562-crna-000020664";s:4:"path";s:15:"/1/172/606/609/";}i:3;a:6:{s:2:"id";s:5:"16661";s:10:"product_id";i:16661;s:4:"name";s:68:"Odmarač nogu-Office Suites™Microban® Protection-podesiv-Fellowes";s:12:"product_name";s:68:"Odmarač nogu-Office Suites™Microban® Protection-podesiv-Fellowes";s:3:"url";s:62:"odmarac-nogu-office-suitesmicroban-protection-podesiv-fellowes";s:4:"path";s:15:"/1/172/606/609/";}i:4;a:6:{s:2:"id";s:5:"92347";s:10:"product_id";i:92347;s:4:"name";s:39:"Odmarač nogu Ultimate Fellowes 8067001";s:12:"product_name";s:39:"Odmarač nogu Ultimate Fellowes 8067001";s:3:"url";s:38:"odmarac-nogu-ultimate-fellowes-8067001";s:4:"path";s:15:"/1/172/606/609/";}}}i:5;a:7:{s:11:"category_id";i:612;s:13:"category_name";s:22:"Podloške za tastature";s:17:"category_name_seo";s:21:"podloske-za-tastature";s:17:"category_name_aim";s:22:"Podloške za tastature";s:14:"category_image";s:18:"612-1675020521.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:6;a:7:{s:11:"category_id";i:611;s:13:"category_name";s:34:"Postolja i ventilatori za Notebook";s:17:"category_name_seo";s:34:"postolja-i-ventilatori-za-notebook";s:17:"category_name_aim";s:34:"Postolja i ventilatori za Notebook";s:14:"category_image";s:18:"611-1675020635.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"115718";s:10:"product_id";i:115718;s:4:"name";s:25:"Hama notebook cooler Wave";s:12:"product_name";s:25:"Hama notebook cooler Wave";s:3:"url";s:25:"hama-notebook-cooler-wave";s:4:"path";s:15:"/1/172/606/611/";}i:1;a:6:{s:2:"id";s:5:"29256";s:10:"product_id";i:29256;s:4:"name";s:42:"USB mini ventilator za notebook 49139 Hama";s:12:"product_name";s:42:"USB mini ventilator za notebook 49139 Hama";s:3:"url";s:42:"usb-mini-ventilator-za-notebook-49139-hama";s:4:"path";s:15:"/1/172/606/611/";}i:2;a:6:{s:2:"id";s:5:"69609";s:10:"product_id";i:69609;s:4:"name";s:48:"Postolje za hladjenje laptopova CP-12 17,3" SBox";s:12:"product_name";s:48:"Postolje za hladjenje laptopova CP-12 17,3" SBox";s:3:"url";s:46:"postolje-za-hladjenje-laptopova-cp-12-173-sbox";s:4:"path";s:15:"/1/172/606/611/";}i:3;a:6:{s:2:"id";s:5:"69608";s:10:"product_id";i:69608;s:4:"name";s:47:"USB Cooling pad za laptop računare CP-101 SBOX";s:12:"product_name";s:47:"USB Cooling pad za laptop računare CP-101 SBOX";s:3:"url";s:46:"usb-cooling-pad-za-laptop-racunare-cp-101-sbox";s:4:"path";s:15:"/1/172/606/611/";}i:4;a:6:{s:2:"id";s:6:"120193";s:10:"product_id";i:120193;s:4:"name";s:60:"Stalak za laptop prenosivi Alumia Fellowes 100138867 srebrni";s:12:"product_name";s:60:"Stalak za laptop prenosivi Alumia Fellowes 100138867 srebrni";s:3:"url";s:60:"stalak-za-laptop-prenosivi-alumia-fellowes-100138867-srebrni";s:4:"path";s:15:"/1/172/606/611/";}}}}s:8:"products";a:0:{}}"
]
19 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:
[
  172
]
20 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:
[
  1790352394
  "cache_tree_oidl_172"
]
21 0.07 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
]
22 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:
[
  1790352394
  "cache_tree_oidl_1"
]
23 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:
[
  1
]
24 0.17 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:
[
  1790352394
  "cache_tree_oidl_1"
]
25 0.12 ms
SELECT id, category_name, category_name_seo, category_image, category_film, category_pdf, description, parent_category_id, level, 
	        	       `timestamp`, show_category, active, fl_alat, category_name_aim, meta_title, meta_description, meta_keywords, created, updated,
	        	       show_eponuda
	        	FROM kategorije 
	        	WHERE id = ? and active = 1
Parameters:
[
  172
]
26 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:
[
  1790352394
  "cache_tree_oidl_172"
]
27 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
]
28 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:
[
  1790352394
  "cache_tree_oidl_1"
]
29 0.07 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.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:
[
  1790352394
  "cache_tree_oidl_1"
]
31 0.11 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:
[
  51611
]
32 0.07 ms
SELECT p.share_link
			FROM proizvodi_filmovi p
			WHERE p.product_id = ? AND p.share_link != '' AND p.active = 1
Parameters:
[
  51611
]
33 0.08 ms
SELECT * 
			FROM proizvodi_rejting_star 
			WHERE product_id = ?
Parameters:
[
  51611
]
34 0.12 ms
SELECT *
			FROM proizvodi_komentari
			WHERE id_proizvoda = ? and active = 1
			ORDER BY vreme DESC
Parameters:
[
  51611
]
35 0.16 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"
]
36 0.20 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:
[
  51611
]
37 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:
[
  611
]
38 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:
[
  1790352394
  "cache_tree_oidl_611"
]
39 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:
[
  606
]
40 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:
[
  1790352394
  "cache_tree_oidl_606"
]
41 0.07 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:
[
  172
]
42 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:
[
  1790352394
  "cache_tree_oidl_172"
]
43 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
]
44 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:
[
  1790352394
  "cache_tree_oidl_1"
]
45 0.07 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
]
46 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:
[
  1790352394
  "cache_tree_oidl_1"
]
47 0.07 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:
[
  172
]
48 0.05 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:
[
  1790352394
  "cache_tree_oidl_172"
]
49 0.04 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
]
50 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:
[
  1790352394
  "cache_tree_oidl_1"
]
51 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
]
52 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:
[
  1790352394
  "cache_tree_oidl_1"
]
53 0.76 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:
[
  611
]
54 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:
[
  1790352394
  "cache_tree_oidl_1"
]
55 0.63 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:
[]
56 19.56 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
57 0.86 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products > 0
Parameters:
[]
58 0.19 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.