Query Metrics

50 Database Queries
12 Different statements
57.40 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.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,
	        	       cache_tree, cache_tree_aim, show_eponuda
	        	FROM kategorije 
	        	WHERE category_name_seo = ? and active = 1
Parameters:
[
  "suveniri"
]
2 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:
[
  1790347845
  "cache_tree_oidl_579"
]
3 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:
[
  579
  579
]
4 8.53 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 => 1790347845
  0 => "cache_tree_oidl_579"
  1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"81646";s:10:"product_id";i:81646;s:4:"name";s:24:"Krigla - Vojoda Momčilo";s:12:"product_name";s:24:"Krigla - Vojoda Momčilo";s:3:"url";s:21:"krigla-vojoda-momcilo";s:4:"path";s:13:"/1/29/84/579/";}i:1;a:6:{s:2:"id";s:5:"81504";s:10:"product_id";i:81504;s:4:"name";s:21:"Krigla Kosovska bitka";s:12:"product_name";s:21:"Krigla Kosovska bitka";s:3:"url";s:21:"krigla-kosovska-bitka";s:4:"path";s:13:"/1/29/84/579/";}i:2;a:6:{s:2:"id";s:5:"81505";s:10:"product_id";i:81505;s:4:"name";s:22:"Krigla kosturska glava";s:12:"product_name";s:22:"Krigla kosturska glava";s:3:"url";s:22:"krigla-kosturska-glava";s:4:"path";s:13:"/1/29/84/579/";}i:3;a:6:{s:2:"id";s:5:"81560";s:10:"product_id";i:81560;s:4:"name";s:21:"Krigla Stefan Nemanja";s:12:"product_name";s:21:"Krigla Stefan Nemanja";s:3:"url";s:21:"krigla-stefan-nemanja";s:4:"path";s:13:"/1/29/84/579/";}i:4;a:6:{s:2:"id";s:5:"81521";s:10:"product_id";i:81521;s:4:"name";s:15:"Krigla rukavica";s:12:"product_name";s:15:"Krigla rukavica";s:3:"url";s:15:"krigla-rukavica";s:4:"path";s:13:"/1/29/84/579/";}}}"
]
5 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:
[
  84
]
6 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:
[
  1790347845
  "cache_tree_oidl_84"
]
7 12.42 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790347845
  "cache_tree_oidl_84"
]
8 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:
[
  84
  84
]
9 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:
[
  891
  891
]
10 0.35 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:
[
  629
  629
]
11 0.30 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:
[
  466
  466
]
12 0.21 ms
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image
	        FROM kategorije k 
	        WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1
	        UNION ALL 
	        (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image
	        FROM kategorije_veze c1, kategorije c2 
	        WHERE c1.category_id = c2.id and c1.parent_category_id = ?  and c1.active = 1 and c2.show_category = 1) 
	        ORDER BY category_name
Parameters:
[
  579
  579
]
13 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:
[
  467
  467
]
14 0.27 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:
[
  468
  468
]
15 8.35 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 => 1790347845
  0 => "cache_tree_oidl_84"
  1 => "a:2:{s:13:"subCategories";a:6:{i:0;a:7:{s:11:"category_id";i:891;s:13:"category_name";s:37:"Jelke novogodišnje i ukrasi za jelke";s:17:"category_name_seo";s:36:"jelke-novogodisnje-i-ukrasi-za-jelke";s:17:"category_name_aim";s:37:"Jelke novogodišnje i ukrasi za jelke";s:14:"category_image";s:18:"891-1664891814.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"76603";s:10:"product_id";i:76603;s:4:"name";s:25:"Girlanda 270 cm 180 grana";s:12:"product_name";s:25:"Girlanda 270 cm 180 grana";s:3:"url";s:25:"girlanda-270-cm-180-grana";s:4:"path";s:13:"/1/29/84/891/";}i:1;a:6:{s:2:"id";s:5:"76557";s:10:"product_id";i:76557;s:4:"name";s:22:"Girlanda 1.80m Ogrlica";s:12:"product_name";s:22:"Girlanda 1.80m Ogrlica";s:3:"url";s:21:"girlanda-180m-ogrlica";s:4:"path";s:13:"/1/29/84/891/";}i:2;a:6:{s:2:"id";s:5:"79505";s:10:"product_id";i:79505;s:4:"name";s:34:"Novogodišnja jelka 120cm STANDARD";s:12:"product_name";s:34:"Novogodišnja jelka 120cm STANDARD";s:3:"url";s:33:"novogodisnja-jelka-120cm-standard";s:4:"path";s:13:"/1/29/84/891/";}i:3;a:6:{s:2:"id";s:5:"59254";s:10:"product_id";i:59254;s:4:"name";s:21:"Girlanda tvrda 250 cm";s:12:"product_name";s:21:"Girlanda tvrda 250 cm";s:3:"url";s:21:"girlanda-tvrda-250-cm";s:4:"path";s:13:"/1/29/84/891/";}i:4;a:6:{s:2:"id";s:5:"90614";s:10:"product_id";i:90614;s:4:"name";s:21:"Girlanda SUPRA 270 CM";s:12:"product_name";s:21:"Girlanda SUPRA 270 CM";s:3:"url";s:21:"girlanda-supra-270-cm";s:4:"path";s:13:"/1/29/84/891/";}}}i:1;a:7:{s:11:"category_id";i:629;s:13:"category_name";s:16:"Otirači za noge";s:17:"category_name_seo";s:15:"otiraci-za-noge";s:17:"category_name_aim";s:16:"Otirači za noge";s:14:"category_image";s:18:"629-1671739359.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"99749";s:10:"product_id";i:99749;s:4:"name";s:25:"Otirač FRYTLE 40x60 siva";s:12:"product_name";s:25:"Otirač FRYTLE 40x60 siva";s:3:"url";s:24:"otirac-frytle-40x60-siva";s:4:"path";s:13:"/1/29/84/629/";}i:1;a:6:{s:2:"id";s:6:"122332";s:10:"product_id";i:122332;s:4:"name";s:27:"Tepih-otirač 70x45cm-braon";s:12:"product_name";s:27:"Tepih-otirač 70x45cm-braon";s:3:"url";s:26:"tepih-otirac-70x45cm-braon";s:4:"path";s:13:"/1/29/84/629/";}i:2;a:6:{s:2:"id";s:6:"122333";s:10:"product_id";i:122333;s:4:"name";s:26:"Tepih-otirač 70x45cm-sivi";s:12:"product_name";s:26:"Tepih-otirač 70x45cm-sivi";s:3:"url";s:25:"tepih-otirac-70x45cm-sivi";s:4:"path";s:13:"/1/29/84/629/";}i:3;a:6:{s:2:"id";s:6:"122237";s:10:"product_id";i:122237;s:4:"name";s:28:"Tepih-otirač 46x76 cm-kamen";s:12:"product_name";s:28:"Tepih-otirač 46x76 cm-kamen";s:3:"url";s:27:"tepih-otirac-46x76-cm-kamen";s:4:"path";s:13:"/1/29/84/629/";}i:4;a:6:{s:2:"id";s:6:"121871";s:10:"product_id";i:121871;s:4:"name";s:34:"Tepih-otirač 45x75 cm-polukružni";s:12:"product_name";s:34:"Tepih-otirač 45x75 cm-polukružni";s:3:"url";s:32:"tepih-otirac-45x75-cm-polukruzni";s:4:"path";s:13:"/1/29/84/629/";}}}i:2;a:7:{s:11:"category_id";i:466;s:13:"category_name";s:32:"Posude za cveće, vaze i saksije";s:17:"category_name_seo";s:30:"posude-za-cvece-vaze-i-saksije";s:17:"category_name_aim";s:32:"Posude za cveće, vaze i saksije";s:14:"category_image";s:18:"466-1675255887.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:3;a:7:{s:11:"category_id";i:579;s:13:"category_name";s:8:"Suveniri";s:17:"category_name_seo";s:8:"suveniri";s:17:"category_name_aim";s:8:"Suveniri";s:14:"category_image";s:18:"579-1675255409.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"81646";s:10:"product_id";i:81646;s:4:"name";s:24:"Krigla - Vojoda Momčilo";s:12:"product_name";s:24:"Krigla - Vojoda Momčilo";s:3:"url";s:21:"krigla-vojoda-momcilo";s:4:"path";s:13:"/1/29/84/579/";}i:1;a:6:{s:2:"id";s:5:"81504";s:10:"product_id";i:81504;s:4:"name";s:21:"Krigla Kosovska bitka";s:12:"product_name";s:21:"Krigla Kosovska bitka";s:3:"url";s:21:"krigla-kosovska-bitka";s:4:"path";s:13:"/1/29/84/579/";}i:2;a:6:{s:2:"id";s:5:"81505";s:10:"product_id";i:81505;s:4:"name";s:22:"Krigla kosturska glava";s:12:"product_name";s:22:"Krigla kosturska glava";s:3:"url";s:22:"krigla-kosturska-glava";s:4:"path";s:13:"/1/29/84/579/";}i:3;a:6:{s:2:"id";s:5:"81560";s:10:"product_id";i:81560;s:4:"name";s:21:"Krigla Stefan Nemanja";s:12:"product_name";s:21:"Krigla Stefan Nemanja";s:3:"url";s:21:"krigla-stefan-nemanja";s:4:"path";s:13:"/1/29/84/579/";}i:4;a:6:{s:2:"id";s:5:"81521";s:10:"product_id";i:81521;s:4:"name";s:15:"Krigla rukavica";s:12:"product_name";s:15:"Krigla rukavica";s:3:"url";s:15:"krigla-rukavica";s:4:"path";s:13:"/1/29/84/579/";}}}i:4;a:7:{s:11:"category_id";i:467;s:13:"category_name";s:13:"Ukrasne korpe";s:17:"category_name_seo";s:13:"ukrasne-korpe";s:17:"category_name_aim";s:13:"Ukrasne korpe";s:14:"category_image";s:18:"467-1675256023.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:6:"102971";s:10:"product_id";i:102971;s:4:"name";s:34:"Ukrasna viseća korpa 300 mm WOMAX";s:12:"product_name";s:34:"Ukrasna viseća korpa 300 mm WOMAX";s:3:"url";s:33:"ukrasna-viseca-korpa-300-mm-womax";s:4:"path";s:13:"/1/29/84/467/";}i:1;a:6:{s:2:"id";s:6:"102972";s:10:"product_id";i:102972;s:4:"name";s:34:"Ukrasna viseća korpa 350 mm WOMAX";s:12:"product_name";s:34:"Ukrasna viseća korpa 350 mm WOMAX";s:3:"url";s:33:"ukrasna-viseca-korpa-350-mm-womax";s:4:"path";s:13:"/1/29/84/467/";}}}i:5;a:7:{s:11:"category_id";i:468;s:13:"category_name";s:26:"Ukrasne sveće i svećnaci";s:17:"category_name_seo";s:24:"ukrasne-svece-i-svecnaci";s:17:"category_name_aim";s:26:"Ukrasne sveće i svećnaci";s:14:"category_image";s:18:"468-1284473351.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}"
]
16 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:
[
  29
]
17 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:
[
  1790347845
  "cache_tree_oidl_29"
]
18 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
]
19 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:
[
  1790347845
  "cache_tree_oidl_1"
]
20 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
]
21 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:
[
  1790347845
  "cache_tree_oidl_1"
]
22 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:
[
  29
]
23 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:
[
  1790347845
  "cache_tree_oidl_29"
]
24 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
]
25 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:
[
  1790347845
  "cache_tree_oidl_1"
]
26 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
]
27 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:
[
  1790347845
  "cache_tree_oidl_1"
]
28 0.15 ms
SELECT page_title, page_meta_description, page_meta_keywords, web_page
	        FROM website_tags
	        WHERE website = ? and web_page IN (?, ?)
Parameters:
[
  1
  "kategorije"
  "ostale"
]
29 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:
[
  579
]
30 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:
[
  1790347845
  "cache_tree_oidl_579"
]
31 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:
[
  84
]
32 0.07 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1790347845
  "cache_tree_oidl_84"
]
33 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:
[
  29
]
34 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:
[
  1790347845
  "cache_tree_oidl_29"
]
35 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:
[
  1
]
36 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:
[
  1790347845
  "cache_tree_oidl_1"
]
37 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
]
38 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:
[
  1790347845
  "cache_tree_oidl_1"
]
39 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:
[
  29
]
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:
[
  1790347845
  "cache_tree_oidl_29"
]
41 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
]
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:
[
  1790347845
  "cache_tree_oidl_1"
]
43 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
]
44 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:
[
  1790347845
  "cache_tree_oidl_1"
]
45 0.62 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:
[
  579
]
46 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:
[
  1790347845
  "cache_tree_oidl_1"
]
47 0.86 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:
[]
48 18.61 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
49 0.58 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products > 0
Parameters:
[]
50 0.07 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.