GET https://dev.alatiimasine.com/proizvodjaci/kapriol/cekici/

Query Metrics

54 Database Queries
14 Different statements
49.48 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 1.03 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 brand_name_seo = ? and active = 1
Parameters:
[
  "kapriol"
]
2 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
]
3 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:
[
  1780969259
  "cache_tree_aim_1"
]
4 2.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,
	        	       cache_tree, cache_tree_aim, show_eponuda
	        	FROM kategorije 
	        	WHERE category_name_seo = ? and active = 1
Parameters:
[
  "cekici"
]
5 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:
[
  1780969259
  "cache_tree_aim_258"
]
6 8.02 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1780969259
  "cache_tree_aim_258"
]
7 0.37 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  258
  258
]
8 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  593
  593
]
9 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  847
  847
]
10 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  597
  597
]
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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  594
  594
]
12 0.26 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  595
  595
]
13 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  596
  596
]
14 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  848
  848
]
15 0.36 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 AND k.fl_alat = 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 AND c2.fl_alat = 1) 
	        ORDER BY category_name
Parameters:
[
  598
  598
]
16 10.88 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 => 1780969259
  0 => "cache_tree_aim_258"
  1 => "a:2:{s:13:"subCategories";a:8:{i:0;a:7:{s:11:"category_id";i:593;s:13:"category_name";s:18:"Čekići bravarski";s:17:"category_name_seo";s:16:"cekici-bravarski";s:17:"category_name_aim";s:18:"Čekići bravarski";s:14:"category_image";s:18:"593-1295966366.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"63927";s:10:"product_id";i:63927;s:4:"name";s:35:"Mašinski čekić 100gr C100 Beorol";s:12:"product_name";s:35:"Mašinski čekić 100gr C100 Beorol";s:3:"url";s:32:"masinski-cekic-100gr-c100-beorol";s:4:"path";s:17:"/1/21/23/258/593/";}i:1;a:6:{s:2:"id";s:5:"59433";s:10:"product_id";i:59433;s:4:"name";s:30:"Čekić bravarski 100gr Modeco";s:12:"product_name";s:30:"Čekić bravarski 100gr Modeco";s:3:"url";s:28:"cekic-bravarski-100gr-modeco";s:4:"path";s:17:"/1/21/23/258/593/";}i:2;a:6:{s:2:"id";s:5:"63941";s:10:"product_id";i:63941;s:4:"name";s:57:"Mašinski čekić sa fiberglas drškom CM100 100gr Beorol";s:12:"product_name";s:57:"Mašinski čekić sa fiberglas drškom CM100 100gr Beorol";s:3:"url";s:53:"masinski-cekic-sa-fiberglas-drskom-cm100-100gr-beorol";s:4:"path";s:17:"/1/21/23/258/593/";}i:3;a:6:{s:2:"id";s:6:"115908";s:10:"product_id";i:115908;s:4:"name";s:58:"Mašinski čekić sa drvenom drškom, 100 g Hogert HT3B001";s:12:"product_name";s:58:"Mašinski čekić sa drvenom drškom, 100 g Hogert HT3B001";s:3:"url";s:53:"masinski-cekic-sa-drvenom-drskom-100-g-hogert-ht3b001";s:4:"path";s:17:"/1/21/23/258/593/";}i:4;a:6:{s:2:"id";s:5:"61562";s:10:"product_id";i:61562;s:4:"name";s:48:"Čekić bravarski sa drvenom drškom 300g LEVIOR";s:12:"product_name";s:48:"Čekić bravarski sa drvenom drškom 300g LEVIOR";s:3:"url";s:45:"cekic-bravarski-sa-drvenom-drskom-300g-levior";s:4:"path";s:17:"/1/21/23/258/593/";}}}i:1;a:7:{s:11:"category_id";i:847;s:13:"category_name";s:15:"Čekići drveni";s:17:"category_name_seo";s:13:"cekici-drveni";s:17:"category_name_aim";s:15:"Čekići drveni";s:14:"category_image";s:18:"847-1619725604.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:5:"28302";s:10:"product_id";i:28302;s:4:"name";s:19:"Čekić drveni WH01";s:12:"product_name";s:19:"Čekić drveni WH01";s:3:"url";s:17:"cekic-drveni-wh01";s:4:"path";s:17:"/1/21/23/258/847/";}i:1;a:6:{s:2:"id";s:5:"47884";s:10:"product_id";i:47884;s:4:"name";s:26:"Drveni čekić 500gr Topex";s:12:"product_name";s:26:"Drveni čekić 500gr Topex";s:3:"url";s:24:"drveni-cekic-500gr-topex";s:4:"path";s:17:"/1/21/23/258/847/";}}}i:2;a:7:{s:11:"category_id";i:597;s:13:"category_name";s:17:"Čekići limarski";s:17:"category_name_seo";s:15:"cekici-limarski";s:17:"category_name_aim";s:17:"Čekići limarski";s:14:"category_image";s:18:"597-1295966782.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"54547";s:10:"product_id";i:54547;s:4:"name";s:33:"Čekić zaobljeni 806 340gr UNIOR";s:12:"product_name";s:33:"Čekić zaobljeni 806 340gr UNIOR";s:3:"url";s:31:"cekic-zaobljeni-806-340gr-unior";s:4:"path";s:17:"/1/21/23/258/597/";}i:1;a:6:{s:2:"id";s:5:"54548";s:10:"product_id";i:54548;s:4:"name";s:33:"Čekić zaobljeni 806 454gr UNIOR";s:12:"product_name";s:33:"Čekić zaobljeni 806 454gr UNIOR";s:3:"url";s:31:"cekic-zaobljeni-806-454gr-unior";s:4:"path";s:17:"/1/21/23/258/597/";}i:2;a:6:{s:2:"id";s:5:"85043";s:10:"product_id";i:85043;s:4:"name";s:51:"Levior limarski čekići - set za popravku limarije";s:12:"product_name";s:51:"Levior limarski čekići - set za popravku limarije";s:3:"url";s:47:"levior-limarski-cekici-set-za-popravku-limarije";s:4:"path";s:17:"/1/21/23/258/597/";}i:3;a:6:{s:2:"id";s:5:"98097";s:10:"product_id";i:98097;s:4:"name";s:44:"HÖGERT HT8G460 Set čekića za limare 7 kom";s:12:"product_name";s:44:"HÖGERT HT8G460 Set čekića za limare 7 kom";s:3:"url";s:40:"hgert-ht8g460-set-cekica-za-limare-7-kom";s:4:"path";s:17:"/1/21/23/258/597/";}i:4;a:6:{s:2:"id";s:6:"108577";s:10:"product_id";i:108577;s:4:"name";s:34:"Yato garnitura autolimarskog alata";s:12:"product_name";s:34:"Yato garnitura autolimarskog alata";s:3:"url";s:34:"yato-garnitura-autolimarskog-alata";s:4:"path";s:17:"/1/21/23/258/597/";}}}i:3;a:7:{s:11:"category_id";i:594;s:13:"category_name";s:15:"Čekići macole";s:17:"category_name_seo";s:13:"cekici-macole";s:17:"category_name_aim";s:15:"Čekići macole";s:14:"category_image";s:18:"594-1675424445.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"110411";s:10:"product_id";i:110411;s:4:"name";s:36:"Macola sa fiber drškom 1.5 kg FESTA";s:12:"product_name";s:36:"Macola sa fiber drškom 1.5 kg FESTA";s:3:"url";s:34:"macola-sa-fiber-drskom-15-kg-festa";s:4:"path";s:17:"/1/21/23/258/594/";}i:1;a:6:{s:2:"id";s:6:"110409";s:10:"product_id";i:110409;s:4:"name";s:34:"Macola sa fiber drškom 4 kg FESTA";s:12:"product_name";s:34:"Macola sa fiber drškom 4 kg FESTA";s:3:"url";s:33:"macola-sa-fiber-drskom-4-kg-festa";s:4:"path";s:17:"/1/21/23/258/594/";}i:2;a:6:{s:2:"id";s:6:"110410";s:10:"product_id";i:110410;s:4:"name";s:34:"Macola sa fiber drškom 2 kg FESTA";s:12:"product_name";s:34:"Macola sa fiber drškom 2 kg FESTA";s:3:"url";s:33:"macola-sa-fiber-drskom-2-kg-festa";s:4:"path";s:17:"/1/21/23/258/594/";}i:3;a:6:{s:2:"id";s:5:"74040";s:10:"product_id";i:74040;s:4:"name";s:25:"Čekić Macola 1kg Modeco";s:12:"product_name";s:25:"Čekić Macola 1kg Modeco";s:3:"url";s:23:"cekic-macola-1kg-modeco";s:4:"path";s:17:"/1/21/23/258/594/";}i:4;a:6:{s:2:"id";s:6:"103934";s:10:"product_id";i:103934;s:4:"name";s:44:"Macola 1500gr sa drvenom drškom 30cm Levior";s:12:"product_name";s:44:"Macola 1500gr sa drvenom drškom 30cm Levior";s:3:"url";s:43:"macola-1500gr-sa-drvenom-drskom-30cm-levior";s:4:"path";s:17:"/1/21/23/258/594/";}}}i:4;a:7:{s:11:"category_id";i:595;s:13:"category_name";s:26:"Čekići plastični-gumeni";s:17:"category_name_seo";s:23:"cekici-plasticni-gumeni";s:17:"category_name_aim";s:26:"Čekići plastični-gumeni";s:14:"category_image";s:18:"595-1675424320.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"113897";s:10:"product_id";i:113897;s:4:"name";s:46:"Čekić gumeni drvena drška O 55/350 g Modeco";s:12:"product_name";s:46:"Čekić gumeni drvena drška O 55/350 g Modeco";s:3:"url";s:42:"cekic-gumeni-drvena-drska-o-55350-g-modeco";s:4:"path";s:17:"/1/21/23/258/595/";}i:1;a:6:{s:2:"id";s:5:"74014";s:10:"product_id";i:74014;s:4:"name";s:46:"Čekić gumeni sa drvenom drškom 450gr Modeco";s:12:"product_name";s:46:"Čekić gumeni sa drvenom drškom 450gr Modeco";s:3:"url";s:43:"cekic-gumeni-sa-drvenom-drskom-450gr-modeco";s:4:"path";s:17:"/1/21/23/258/595/";}i:2;a:6:{s:2:"id";s:5:"28305";s:10:"product_id";i:28305;s:4:"name";s:19:"Čekič gumeni 340g";s:12:"product_name";s:19:"Čekič gumeni 340g";s:3:"url";s:17:"cekic-gumeni-340g";s:4:"path";s:17:"/1/21/23/258/595/";}i:3;a:6:{s:2:"id";s:5:"77984";s:10:"product_id";i:77984;s:4:"name";s:27:"Čekić gumeni 400gr Levior";s:12:"product_name";s:27:"Čekić gumeni 400gr Levior";s:3:"url";s:25:"cekic-gumeni-400gr-levior";s:4:"path";s:17:"/1/21/23/258/595/";}i:4;a:6:{s:2:"id";s:5:"95835";s:10:"product_id";i:95835;s:4:"name";s:56:"Gumeni čekić sa metalnom drškom 45/450 gr Home Modeco";s:12:"product_name";s:56:"Gumeni čekić sa metalnom drškom 45/450 gr Home Modeco";s:3:"url";s:52:"gumeni-cekic-sa-metalnom-drskom-45450-gr-home-modeco";s:4:"path";s:17:"/1/21/23/258/595/";}}}i:5;a:7:{s:11:"category_id";i:596;s:13:"category_name";s:17:"Čekići tesarski";s:17:"category_name_seo";s:15:"cekici-tesarski";s:17:"category_name_aim";s:17:"Čekići tesarski";s:14:"category_image";s:18:"596-1619725981.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"73109";s:10:"product_id";i:73109;s:4:"name";s:29:"Čekić tesarski 16oz Machtig";s:12:"product_name";s:29:"Čekić tesarski 16oz Machtig";s:3:"url";s:27:"cekic-tesarski-16oz-machtig";s:4:"path";s:17:"/1/21/23/258/596/";}i:1;a:6:{s:2:"id";s:5:"71913";s:10:"product_id";i:71913;s:4:"name";s:27:"Keser sa drškom 380g Womax";s:12:"product_name";s:27:"Keser sa drškom 380g Womax";s:3:"url";s:26:"keser-sa-drskom-380g-womax";s:4:"path";s:17:"/1/21/23/258/596/";}i:2;a:6:{s:2:"id";s:5:"54526";s:10:"product_id";i:54526;s:4:"name";s:29:"Čekić tesarski 600gr LEVIOR";s:12:"product_name";s:29:"Čekić tesarski 600gr LEVIOR";s:3:"url";s:27:"cekic-tesarski-600gr-levior";s:4:"path";s:17:"/1/21/23/258/596/";}i:3;a:6:{s:2:"id";s:5:"59863";s:10:"product_id";i:59863;s:4:"name";s:34:"Čekić tesarski 600gr sivi LEVIOR";s:12:"product_name";s:34:"Čekić tesarski 600gr sivi LEVIOR";s:3:"url";s:32:"cekic-tesarski-600gr-sivi-levior";s:4:"path";s:17:"/1/21/23/258/596/";}i:4;a:6:{s:2:"id";s:5:"59991";s:10:"product_id";i:59991;s:4:"name";s:49:"Čekić tesarski 600gr sa fiberglas drškom FESTA";s:12:"product_name";s:49:"Čekić tesarski 600gr sa fiberglas drškom FESTA";s:3:"url";s:46:"cekic-tesarski-600gr-sa-fiberglas-drskom-festa";s:4:"path";s:17:"/1/21/23/258/596/";}}}i:6;a:7:{s:11:"category_id";i:848;s:13:"category_name";s:20:"Čekići za keramiku";s:17:"category_name_seo";s:18:"cekici-za-keramiku";s:17:"category_name_aim";s:20:"Čekići za keramiku";s:14:"category_image";s:18:"848-1675424650.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:7;a:7:{s:11:"category_id";i:598;s:13:"category_name";s:17:"Čekići zidarski";s:17:"category_name_seo";s:15:"cekici-zidarski";s:17:"category_name_aim";s:17:"Čekići zidarski";s:14:"category_image";s:18:"598-1295966848.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"74046";s:10:"product_id";i:74046;s:4:"name";s:57:"Zidarski čekić široki 600gr sa metalnom drškom Modeco";s:12:"product_name";s:57:"Zidarski čekić široki 600gr sa metalnom drškom Modeco";s:3:"url";s:53:"zidarski-cekic-siroki-600gr-sa-metalnom-drskom-modeco";s:4:"path";s:17:"/1/21/23/258/598/";}i:1;a:6:{s:2:"id";s:5:"74048";s:10:"product_id";i:74048;s:4:"name";s:49:"Zidarski čekić 600gr sa metalnom drškom Modeco";s:12:"product_name";s:49:"Zidarski čekić 600gr sa metalnom drškom Modeco";s:3:"url";s:46:"zidarski-cekic-600gr-sa-metalnom-drskom-modeco";s:4:"path";s:17:"/1/21/23/258/598/";}i:2;a:6:{s:2:"id";s:5:"47997";s:10:"product_id";i:47997;s:4:"name";s:27:"Čekić zidarski 600g TOPEX";s:12:"product_name";s:27:"Čekić zidarski 600g TOPEX";s:3:"url";s:25:"cekic-zidarski-600g-topex";s:4:"path";s:17:"/1/21/23/258/598/";}i:3;a:6:{s:2:"id";s:6:"118025";s:10:"product_id";i:118025;s:4:"name";s:47:"Čekic GD 600g sa metalnom drškom 249905 304OM";s:12:"product_name";s:47:"Čekic GD 600g sa metalnom drškom 249905 304OM";s:3:"url";s:45:"cekic-gd-600g-sa-metalnom-drskom-249905-304om";s:4:"path";s:17:"/1/21/23/258/598/";}i:4;a:6:{s:2:"id";s:5:"60495";s:10:"product_id";i:60495;s:4:"name";s:46:"Čekić zidarski sa drvenom drškom 540g FESTA";s:12:"product_name";s:46:"Čekić zidarski sa drvenom drškom 540g FESTA";s:3:"url";s:43:"cekic-zidarski-sa-drvenom-drskom-540g-festa";s:4:"path";s:17:"/1/21/23/258/598/";}}}}s:8:"products";a:0:{}}"
]
17 0.18 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:
[
  23
]
18 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:
[
  1780969259
  "cache_tree_aim_23"
]
19 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:
[
  21
]
20 0.15 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:
[
  1780969259
  "cache_tree_aim_21"
]
21 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:
[
  1
]
22 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:
[
  1780969259
  "cache_tree_aim_1"
]
23 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:
[
  1
]
24 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:
[
  1780969259
  "cache_tree_aim_1"
]
25 0.13 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:
[
  21
]
26 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:
[
  1780969259
  "cache_tree_aim_21"
]
27 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:
[
  1
]
28 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:
[
  1780969259
  "cache_tree_aim_1"
]
29 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:
[
  1
]
30 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:
[
  1780969259
  "cache_tree_aim_1"
]
31 0.30 ms
SELECT k.id, k.category_name, k.category_name_seo, k.category_image, k.parent_category_id, k.level, 
	        	       k.show_category, k.active, k.fl_alat, k.category_name_aim
	        	FROM kategorije k
	        	INNER JOIN brand_to_category bc ON k.id = bc.fk_category_id AND bc.fk_brand_id = ?
	        	WHERE parent_category_id = ? AND active = 1 AND k.fl_alat = 1
Parameters:
[
  15
  258
]
32 0.17 ms
SELECT page_title, page_meta_description, page_meta_keywords, web_page
	        FROM website_tags
	        WHERE website = ? and web_page IN (?, ?)
Parameters:
[
  2
  "brendovi"
  "ostale"
]
33 0.20 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:
[
  258
]
34 0.18 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:
[
  1780969259
  "cache_tree_aim_258"
]
35 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:
[
  23
]
36 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:
[
  1780969259
  "cache_tree_aim_23"
]
37 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:
[
  21
]
38 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:
[
  1780969259
  "cache_tree_aim_21"
]
39 0.13 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
]
40 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:
[
  1780969259
  "cache_tree_aim_1"
]
41 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:
[
  1
]
42 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:
[
  1780969259
  "cache_tree_aim_1"
]
43 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:
[
  21
]
44 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:
[
  1780969259
  "cache_tree_aim_21"
]
45 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:
[
  1
]
46 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:
[
  1780969259
  "cache_tree_aim_1"
]
47 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:
[
  1
]
48 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:
[
  1780969259
  "cache_tree_aim_1"
]
49 1.77 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 = ? AND p.fl_alat = 1
			GROUP BY p.brand_id
			ORDER BY b.brand_name
Parameters:
[
  258
]
50 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:
[
  1780969259
  "cache_tree_aim_21"
]
51 0.66 ms
SELECT b.id AS brand_id, b.brand_name, b.num_of_products_aim AS broj_proizvoda
			FROM proizvodjaci b
			WHERE b.active = 1 AND b.show_brand = 1
			ORDER BY broj_proizvoda DESC
			LIMIT 25
Parameters:
[]
52 16.90 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
53 0.45 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products_aim > 0
Parameters:
[]
54 0.09 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.