GET https://dev.alatiimasine.com/kategorija/zavese/

Query Metrics

27 Database Queries
6 Different statements
29.67 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 2.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,
	        	       cache_tree, cache_tree_aim, show_eponuda
	        	FROM kategorije 
	        	WHERE category_name_seo = ? and active = 1
Parameters:
[
  "zavese"
]
2 0.24 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:
[
  1790348060
  "cache_tree_oidl_838"
]
3 0.39 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:
[
  838
  838
]
4 9.42 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 => 1790348060
  0 => "cache_tree_oidl_838"
  1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}"
]
5 0.26 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:
[
  693
]
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:
[
  1790348060
  "cache_tree_oidl_693"
]
7 0.29 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:
[
  693
  693
]
8 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:
[
  840
  840
]
9 0.28 ms
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image
	        FROM kategorije k 
	        WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1
	        UNION ALL 
	        (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image
	        FROM kategorije_veze c1, kategorije c2 
	        WHERE c1.category_id = c2.id and c1.parent_category_id = ?  and c1.active = 1 and c2.show_category = 1) 
	        ORDER BY category_name
Parameters:
[
  839
  839
]
10 0.28 ms
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image
	        FROM kategorije k 
	        WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1
	        UNION ALL 
	        (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image
	        FROM kategorije_veze c1, kategorije c2 
	        WHERE c1.category_id = c2.id and c1.parent_category_id = ?  and c1.active = 1 and c2.show_category = 1) 
	        ORDER BY category_name
Parameters:
[
  841
  841
]
11 0.28 ms
SELECT k.id AS category_id, k.category_name, k.category_name_seo, k.category_name_aim, k.category_image
	        FROM kategorije k 
	        WHERE k.parent_category_id = ? and k.active = 1 and k.show_category = 1
	        UNION ALL 
	        (SELECT c1.category_id, c2.category_name, c2.category_name_seo, c2.category_name_aim, c2.category_image
	        FROM kategorije_veze c1, kategorije c2 
	        WHERE c1.category_id = c2.id and c1.parent_category_id = ?  and c1.active = 1 and c2.show_category = 1) 
	        ORDER BY category_name
Parameters:
[
  842
  842
]
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
	        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:
[
  838
  838
]
13 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:
[
  490
  490
]
14 10.89 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 => 1790348060
  0 => "cache_tree_oidl_693"
  1 => "a:2:{s:13:"subCategories";a:6:{i:0;a:7:{s:11:"category_id";i:840;s:13:"category_name";s:18:"Garnišle i dodaci";s:17:"category_name_seo";s:17:"garnisle-i-dodaci";s:17:"category_name_aim";s:9:"Garnišle";s:14:"category_image";s:18:"840-1675171070.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:1:{i:0;a:6:{s:2:"id";s:6:"101745";s:10:"product_id";i:101745;s:4:"name";s:35:"Klizači za FIXI šinu 50kom/p bela";s:12:"product_name";s:35:"Klizači za FIXI šinu 50kom/p bela";s:3:"url";s:32:"klizaci-za-fixi-sinu-50komp-bela";s:4:"path";s:14:"/1/29/693/840/";}}}i:1;a:7:{s:11:"category_id";i:839;s:13:"category_name";s:7:"Roletne";s:17:"category_name_seo";s:7:"roletne";s:17:"category_name_aim";s:7:"Roletne";s:14:"category_image";s:18:"839-1320137998.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:2;a:7:{s:11:"category_id";i:841;s:13:"category_name";s:15:"Trakaste zavese";s:17:"category_name_seo";s:15:"trakaste-zavese";s:17:"category_name_aim";s:15:"Trakaste zavese";s:14:"category_image";s:18:"841-1675171096.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:3:{i:0;a:6:{s:2:"id";s:5:"97604";s:10:"product_id";i:97604;s:4:"name";s:29:"Rolo bambus 90x200 cm 3 vrste";s:12:"product_name";s:29:"Rolo bambus 90x200 cm 3 vrste";s:3:"url";s:29:"rolo-bambus-90x200-cm-3-vrste";s:4:"path";s:14:"/1/29/693/841/";}i:1;a:6:{s:2:"id";s:5:"97607";s:10:"product_id";i:97607;s:4:"name";s:39:"Rolo bambus 90x200 cm 3 vrste 95-390000";s:12:"product_name";s:39:"Rolo bambus 90x200 cm 3 vrste 95-390000";s:3:"url";s:39:"rolo-bambus-90x200-cm-3-vrste-95-390000";s:4:"path";s:14:"/1/29/693/841/";}i:2;a:6:{s:2:"id";s:5:"97603";s:10:"product_id";i:97603;s:4:"name";s:30:"Rolo bambus 120x200 cm 3 vrste";s:12:"product_name";s:30:"Rolo bambus 120x200 cm 3 vrste";s:3:"url";s:30:"rolo-bambus-120x200-cm-3-vrste";s:4:"path";s:14:"/1/29/693/841/";}}}i:3;a:7:{s:11:"category_id";i:842;s:13:"category_name";s:12:"Venecijaneri";s:17:"category_name_seo";s:12:"venecijaneri";s:17:"category_name_aim";s:12:"Venecijaneri";s:14:"category_image";s:18:"842-1675171120.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:4;a:7:{s:11:"category_id";i:838;s:13:"category_name";s:6:"Zavese";s:17:"category_name_seo";s:6:"zavese";s:17:"category_name_aim";s:6:"Zavese";s:14:"category_image";s:18:"838-1675171141.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:0:{}}i:5;a:7:{s:11:"category_id";i:490;s:13:"category_name";s:27:"Zavese i šipke za kupatilo";s:17:"category_name_seo";s:26:"zavese-i-sipke-za-kupatilo";s:17:"category_name_aim";s:27:"Zavese i šipke za kupatilo";s:14:"category_image";s:18:"490-1675171179.jpg";s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"27580";s:10:"product_id";i:27580;s:4:"name";s:28:"Tuš-zavesa SYLVIE 150x200cm";s:12:"product_name";s:28:"Tuš-zavesa SYLVIE 150x200cm";s:3:"url";s:27:"tus-zavesa-sylvie-150x200cm";s:4:"path";s:17:"/1/29/33/485/490/";}i:1;a:6:{s:2:"id";s:5:"83653";s:10:"product_id";i:83653;s:4:"name";s:54:"Zavesa za kupatilo ljubičasta 180x200cm CN7339 Diplon";s:12:"product_name";s:54:"Zavesa za kupatilo ljubičasta 180x200cm CN7339 Diplon";s:3:"url";s:53:"zavesa-za-kupatilo-ljubicasta-180x200cm-cn7339-diplon";s:4:"path";s:17:"/1/29/33/485/490/";}i:2;a:6:{s:2:"id";s:5:"83654";s:10:"product_id";i:83654;s:4:"name";s:49:"Zavesa za kupatilo Nature 180x200cm CN7306 Diplon";s:12:"product_name";s:49:"Zavesa za kupatilo Nature 180x200cm CN7306 Diplon";s:3:"url";s:49:"zavesa-za-kupatilo-nature-180x200cm-cn7306-diplon";s:4:"path";s:17:"/1/29/33/485/490/";}i:3;a:6:{s:2:"id";s:5:"83662";s:10:"product_id";i:83662;s:4:"name";s:52:"Zavesa za kupatilo crno-bela 180x200cm CN7342 Diplon";s:12:"product_name";s:52:"Zavesa za kupatilo crno-bela 180x200cm CN7342 Diplon";s:3:"url";s:52:"zavesa-za-kupatilo-crno-bela-180x200cm-cn7342-diplon";s:4:"path";s:17:"/1/29/33/485/490/";}i:4;a:6:{s:2:"id";s:5:"83666";s:10:"product_id";i:83666;s:4:"name";s:39:"Zavesa za kupatilo Sovice CN7338 Diplon";s:12:"product_name";s:39:"Zavesa za kupatilo Sovice CN7338 Diplon";s:3:"url";s:39:"zavesa-za-kupatilo-sovice-cn7338-diplon";s:4:"path";s:17:"/1/29/33/485/490/";}}}}s:8:"products";a:0:{}}"
]
15 0.35 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
]
16 0.24 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:
[
  1790348060
  "cache_tree_oidl_29"
]
17 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:
[
  1
]
18 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:
[
  1790348060
  "cache_tree_oidl_1"
]
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:
[
  1
]
20 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:
[
  1790348060
  "cache_tree_oidl_1"
]
21 0.25 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
]
22 0.20 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:
[
  1790348060
  "cache_tree_oidl_29"
]
23 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:
[
  1
]
24 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:
[
  1790348060
  "cache_tree_oidl_1"
]
25 0.31 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
]
26 0.24 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:
[
  1790348060
  "cache_tree_oidl_1"
]
27 1.56 ms
SELECT COUNT(*) AS broj_proizvoda 
			FROM proizvodi 
			WHERE category_id = ?  AND show_product = 1 AND active = 1 AND (copy_from_id is NULL OR copy_from_id = '')
Parameters:
[
  838
]

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.