Query Metrics

37 Database Queries
12 Different statements
41.95 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.43 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:
[
  "magnetni-steznici"
]
2 0.22 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:
[
  1790352392
  "cache_tree_oidl_696"
]
3 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:
[
  399
]
4 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:
[
  1790352392
  "cache_tree_oidl_399"
]
5 8.09 ms
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
Parameters:
[
  1790352392
  "cache_tree_oidl_399"
]
6 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:
[
  399
  399
]
7 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
	        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:
[
  753
  753
]
8 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:
[
  544
  544
]
9 0.11 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:
[
  369
  369
]
10 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:
[
  704
  704
]
11 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:
[
  696
  696
]
12 0.13 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:
[
  401
  401
]
13 0.11 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:
[
  400
  400
]
14 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:
[
  703
  703
]
15 0.13 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:
[
  694
  694
]
16 0.12 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:
[
  554
  554
]
17 0.11 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:
[
  975
  975
]
18 10.79 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 => 1790352392
  0 => "cache_tree_oidl_399"
  1 => "a:2:{s:13:"subCategories";a:11:{i:0;a:7:{s:11:"category_id";i:753;s:13:"category_name";s:19:"Aparati za brijanje";s:17:"category_name_seo";s:19:"aparati-za-brijanje";s:17:"category_name_aim";s:19:"Aparati za brijanje";s:14:"category_image";s:18:"753-1317557663.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"108427";s:10:"product_id";i:108427;s:4:"name";s:50:"Rosberg mašinica za brijanje Rosberg R51814B crna";s:12:"product_name";s:50:"Rosberg mašinica za brijanje Rosberg R51814B crna";s:3:"url";s:49:"rosberg-masinica-za-brijanje-rosberg-r51814b-crna";s:4:"path";s:14:"/1/29/368/753/";}i:1;a:6:{s:2:"id";s:5:"77356";s:10:"product_id";i:77356;s:4:"name";s:36:"Brijač PC-HR 3053 S sivi PROFI CARE";s:12:"product_name";s:36:"Brijač PC-HR 3053 S sivi PROFI CARE";s:3:"url";s:35:"brijac-pc-hr-3053-s-sivi-profi-care";s:4:"path";s:14:"/1/29/368/753/";}i:2;a:6:{s:2:"id";s:6:"104729";s:10:"product_id";i:104729;s:4:"name";s:28:"Taurus trimer za bradu HADES";s:12:"product_name";s:28:"Taurus trimer za bradu HADES";s:3:"url";s:28:"taurus-trimer-za-bradu-hades";s:4:"path";s:14:"/1/29/368/753/";}i:3;a:6:{s:2:"id";s:5:"89362";s:10:"product_id";i:89362;s:4:"name";s:31:"MESKO Aparat za brijanje MS2920";s:12:"product_name";s:31:"MESKO Aparat za brijanje MS2920";s:3:"url";s:31:"mesko-aparat-za-brijanje-ms2920";s:4:"path";s:14:"/1/29/368/753/";}i:4;a:6:{s:2:"id";s:6:"107447";s:10:"product_id";i:107447;s:4:"name";s:49:"XIAOMI Mi električni brijač S101 EU (BHR7456EU)";s:12:"product_name";s:49:"XIAOMI Mi električni brijač S101 EU (BHR7456EU)";s:3:"url";s:45:"xiaomi-mi-elektricni-brijac-s101-eu-bhr7456eu";s:4:"path";s:14:"/1/29/368/753/";}}}i:1;a:7:{s:11:"category_id";i:544;s:13:"category_name";s:20:"Aparati za šišanje";s:17:"category_name_seo";s:18:"aparati-za-sisanje";s:17:"category_name_aim";s:20:"Aparati za šišanje";s:14:"category_image";s:18:"544-1675077288.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"60775";s:10:"product_id";i:60775;s:4:"name";s:35:"Higijenski trimer NE 3595 CLATRONIC";s:12:"product_name";s:35:"Higijenski trimer NE 3595 CLATRONIC";s:3:"url";s:35:"higijenski-trimer-ne-3595-clatronic";s:4:"path";s:14:"/1/29/368/544/";}i:1;a:6:{s:2:"id";s:5:"79208";s:10:"product_id";i:79208;s:4:"name";s:39:"Mašinica za šišanje EBC002 ESPERANZA";s:12:"product_name";s:39:"Mašinica za šišanje EBC002 ESPERANZA";s:3:"url";s:36:"masinica-za-sisanje-ebc002-esperanza";s:4:"path";s:14:"/1/29/368/544/";}i:2;a:6:{s:2:"id";s:5:"39046";s:10:"product_id";i:39046;s:4:"name";s:37:"Aparat za šišanje CSS-6290 COLOSSUS";s:12:"product_name";s:37:"Aparat za šišanje CSS-6290 COLOSSUS";s:3:"url";s:33:"aparat-za-sisanje-cs-6290-colosus";s:4:"path";s:14:"/1/29/368/544/";}i:3;a:6:{s:2:"id";s:5:"53705";s:10:"product_id";i:53705;s:4:"name";s:38:"Aparat za šišanje CSS-6290B COLOSSUS";s:12:"product_name";s:38:"Aparat za šišanje CSS-6290B COLOSSUS";s:3:"url";s:34:"aparat-za-sisanje-cs-6290b-colosus";s:4:"path";s:14:"/1/29/368/544/";}i:4;a:6:{s:2:"id";s:6:"117970";s:10:"product_id";i:117970;s:4:"name";s:41:"Mašinica za šišanje OV51810H 9W 2336OM";s:12:"product_name";s:41:"Mašinica za šišanje OV51810H 9W 2336OM";s:3:"url";s:38:"masinica-za-sisanje-ov51810h-9w-2336om";s:4:"path";s:14:"/1/29/368/544/";}}}i:2;a:7:{s:11:"category_id";i:369;s:13:"category_name";s:10:"Depilatori";s:17:"category_name_seo";s:10:"depilatori";s:17:"category_name_aim";s:10:"Depilatori";s:14:"category_image";s:18:"369-1272999002.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"91166";s:10:"product_id";i:91166;s:4:"name";s:40:"ESPERANZA brijač za žene ARUBA EBG003B";s:12:"product_name";s:40:"ESPERANZA brijač za žene ARUBA EBG003B";s:3:"url";s:38:"esperanza-brijac-za-zene-aruba-ebg003b";s:4:"path";s:14:"/1/29/368/369/";}i:1;a:6:{s:2:"id";s:5:"89770";s:10:"product_id";i:89770;s:4:"name";s:26:"ESPERANZA Epilator EBD002B";s:12:"product_name";s:26:"ESPERANZA Epilator EBD002B";s:3:"url";s:26:"esperanza-epilator-ebd002b";s:4:"path";s:14:"/1/29/368/369/";}i:2;a:6:{s:2:"id";s:5:"72140";s:10:"product_id";i:72140;s:4:"name";s:26:"Epilator CSS-6200 COLOSSUS";s:12:"product_name";s:26:"Epilator CSS-6200 COLOSSUS";s:3:"url";s:24:"epilator-cs-6200-colosus";s:4:"path";s:14:"/1/29/368/369/";}i:3;a:6:{s:2:"id";s:5:"99265";s:10:"product_id";i:99265;s:4:"name";s:24:"ROWENTA depilator EP1110";s:12:"product_name";s:24:"ROWENTA depilator EP1110";s:3:"url";s:24:"rowenta-depilator-ep1110";s:4:"path";s:14:"/1/29/368/369/";}i:4;a:6:{s:2:"id";s:5:"81299";s:10:"product_id";i:81299;s:4:"name";s:45:"Brijač Lady shave wet & dry LSW1PE1001 Silkn";s:12:"product_name";s:45:"Brijač Lady shave wet & dry LSW1PE1001 Silkn";s:3:"url";s:42:"brijac-lady-shave-wet-dry-lsw1pe1001-silkn";s:4:"path";s:14:"/1/29/368/369/";}}}i:3;a:7:{s:11:"category_id";i:704;s:13:"category_name";s:17:"Magnetna terapija";s:17:"category_name_seo";s:17:"magnetna-terapija";s:17:"category_name_aim";s:17:"Magnetna terapija";s:14:"category_image";s:18:"704-1675078062.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:4;a:7:{s:11:"category_id";i:696;s:13:"category_name";s:17:"Magnetni steznici";s:17:"category_name_seo";s:17:"magnetni-steznici";s:17:"category_name_aim";s:17:"Magnetni steznici";s:14:"category_image";s:18:"696-1675077205.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:5;a:7:{s:11:"category_id";i:401;s:13:"category_name";s:17:"Manikir i pedikir";s:17:"category_name_seo";s:17:"manikir-i-pedikir";s:17:"category_name_aim";s:17:"Manikir i pedikir";s:14:"category_image";s:18:"401-1675077922.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"105381";s:10:"product_id";i:105381;s:4:"name";s:33:"O’vinna LED/UV lampa za manikir";s:12:"product_name";s:33:"O’vinna LED/UV lampa za manikir";s:3:"url";s:29:"ovinna-leduv-lampa-za-manikir";s:4:"path";s:11:"/1/399/401/";}i:1;a:6:{s:2:"id";s:5:"89742";s:10:"product_id";i:89742;s:4:"name";s:51:"ESPERANZA UV LED lampa sušač laka za nokte EBN010";s:12:"product_name";s:51:"ESPERANZA UV LED lampa sušač laka za nokte EBN010";s:3:"url";s:49:"esperanza-uv-led-lampa-susac-laka-za-nokte-ebn010";s:4:"path";s:11:"/1/399/401/";}i:2;a:6:{s:2:"id";s:5:"80841";s:10:"product_id";i:80841;s:4:"name";s:39:"UV lampa za nokte 36W EBN001P ESPERANZA";s:12:"product_name";s:39:"UV lampa za nokte 36W EBN001P ESPERANZA";s:3:"url";s:39:"uv-lampa-za-nokte-36w-ebn001p-esperanza";s:4:"path";s:11:"/1/399/401/";}i:3;a:6:{s:2:"id";s:6:"105397";s:10:"product_id";i:105397;s:4:"name";s:24:"SHELLALAH Set za manikir";s:12:"product_name";s:24:"SHELLALAH Set za manikir";s:3:"url";s:24:"shellalah-set-za-manikir";s:4:"path";s:11:"/1/399/401/";}i:4;a:6:{s:2:"id";s:5:"79307";s:10:"product_id";i:79307;s:4:"name";s:38:"UV LED lampa za nokte EBN006 ESPERANZA";s:12:"product_name";s:38:"UV LED lampa za nokte EBN006 ESPERANZA";s:3:"url";s:38:"uv-led-lampa-za-nokte-ebn006-esperanza";s:4:"path";s:11:"/1/399/401/";}}}i:6;a:7:{s:11:"category_id";i:400;s:13:"category_name";s:18:"Medicinski aparati";s:17:"category_name_seo";s:18:"medicinski-aparati";s:17:"category_name_aim";s:18:"Medicinski aparati";s:14:"category_image";s:18:"400-1675077020.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:7;a:7:{s:11:"category_id";i:703;s:13:"category_name";s:16:"Nakit od magneta";s:17:"category_name_seo";s:16:"nakit-od-magneta";s:17:"category_name_aim";s:16:"Nakit od magneta";s:14:"category_image";s:18:"703-1675077442.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:8;a:7:{s:11:"category_id";i:694;s:13:"category_name";s:21:"Prečišćavanje vode";s:17:"category_name_seo";s:18:"preciscavanje-vode";s:17:"category_name_aim";s:21:"Prečišćavanje vode";s:14:"category_image";s:18:"694-1308571339.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"107117";s:10:"product_id";i:107117;s:4:"name";s:40:"Filter patrona BWT sa mineralizatorom Mg";s:12:"product_name";s:40:"Filter patrona BWT sa mineralizatorom Mg";s:3:"url";s:40:"filter-patrona-bwt-sa-mineralizatorom-mg";s:4:"path";s:10:"/1/29/694/";}i:1;a:6:{s:2:"id";s:6:"107134";s:10:"product_id";i:107134;s:4:"name";s:45:"Flašica za filtriranje vode Dafi 0,5L crvena";s:12:"product_name";s:45:"Flašica za filtriranje vode Dafi 0,5L crvena";s:3:"url";s:43:"flasica-za-filtriranje-vode-dafi-05l-crvena";s:4:"path";s:10:"/1/29/694/";}i:2;a:6:{s:2:"id";s:6:"107135";s:10:"product_id";i:107135;s:4:"name";s:44:"Flašica za filtriranje vode Dafi 0,5L plava";s:12:"product_name";s:44:"Flašica za filtriranje vode Dafi 0,5L plava";s:3:"url";s:42:"flasica-za-filtriranje-vode-dafi-05l-plava";s:4:"path";s:10:"/1/29/694/";}i:3;a:6:{s:2:"id";s:6:"107120";s:10:"product_id";i:107120;s:4:"name";s:35:"Filter bokal Dafi Atria 2,4L grafit";s:12:"product_name";s:35:"Filter bokal Dafi Atria 2,4L grafit";s:3:"url";s:34:"filter-bokal-dafi-atria-24l-grafit";s:4:"path";s:10:"/1/29/694/";}i:4;a:6:{s:2:"id";s:6:"107121";s:10:"product_id";i:107121;s:4:"name";s:35:"Filter bokal Dafi Atria 2,4L crveni";s:12:"product_name";s:35:"Filter bokal Dafi Atria 2,4L crveni";s:3:"url";s:34:"filter-bokal-dafi-atria-24l-crveni";s:4:"path";s:10:"/1/29/694/";}}}i:9;a:7:{s:11:"category_id";i:554;s:13:"category_name";s:18:"Stolovi za masažu";s:17:"category_name_seo";s:17:"stolovi-za-masazu";s:17:"category_name_aim";s:18:"Stolovi za masažu";s:14:"category_image";s:18:"554-1675078188.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:10;a:7:{s:11:"category_id";i:975;s:13:"category_name";s:20:"Veštačke trepavice";s:17:"category_name_seo";s:18:"vestacke-trepavice";s:17:"category_name_aim";s:20:"Veštačke trepavice";s:14:"category_image";s:18:"975-1330786122.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}}s:8:"products";a:0:{}}"
]
19 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
]
20 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:
[
  1790352392
  "cache_tree_oidl_1"
]
21 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
]
22 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:
[
  1790352392
  "cache_tree_oidl_1"
]
23 0.09 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"
]
24 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:
[
  696
]
25 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:
[
  1790352392
  "cache_tree_oidl_696"
]
26 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:
[
  399
]
27 0.04 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:
[
  1790352392
  "cache_tree_oidl_399"
]
28 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
]
29 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:
[
  1790352392
  "cache_tree_oidl_1"
]
30 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
]
31 0.04 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:
[
  1790352392
  "cache_tree_oidl_1"
]
32 0.27 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:
[
  696
]
33 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:
[
  1790352392
  "cache_tree_oidl_1"
]
34 0.52 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:
[]
35 16.96 ms
SELECT COUNT(p.id) AS uk_broj_aktivnih 
            FROM proizvodi p 
            WHERE p.active = 1 AND p.show_product = 1
Parameters:
[]
36 0.42 ms
SELECT COUNT(*) AS num_brands
                                FROM proizvodjaci b
                              	WHERE  active = 1 AND show_brand = 1 AND num_of_products > 0
Parameters:
[]
37 0.04 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.