1
1.49 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 :
[
"bastenski-stolovi "
]
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 = 'bastenski-stolovi' and active = 1 ;
Copy
2
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 :
[
1790352407
"cache_tree_oidl_961 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_961' );
Copy
3
8.19 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1790352407
"cache_tree_oidl_961 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1790352407 AND item_id IN ('cache_tree_oidl_961' );
Copy
4
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
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 = 961 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 = 961 and c1 . active = 1 and c2 . show_category = 1 )
ORDER BY category_name ;
Copy
5
7.67 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 => 1790352407
0 => "cache_tree_oidl_961 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"64535";s:10:"product_id";i:64535;s:4:"name";s:38:"Sto plastični 760x500xH580x48 mm Haus";s:12:"product_name";s:38:"Sto plastični 760x500xH580x48 mm Haus";s:3:"url";s:37:"sto-plasticni-760x500xh580x48-mm-haus";s:4:"path";s:13:"/1/44/97/961/";}i:1;a:6:{s:2:"id";s:5:"65324";s:10:"product_id";i:65324;s:4:"name";s:54:"Baštenski sto okrugli 80cm crno kaljeno staklo Milano";s:12:"product_name";s:54:"Baštenski sto okrugli 80cm crno kaljeno staklo Milano";s:3:"url";s:53:"bastenski-sto-okrugli-80cm-crno-kaljeno-staklo-milano";s:4:"path";s:13:"/1/44/97/961/";}i:2;a:6:{s:2:"id";s:5:"59541";s:10:"product_id";i:59541;s:4:"name";s:36:"Stočić Ø60X70cm metal/staklo crni";s:12:"product_name";s:36:"Stočić Ø60X70cm metal/staklo crni";s:3:"url";s:31:"stocic-60x70cm-metalstaklo-crni";s:4:"path";s:13:"/1/44/97/961/";}i:3;a:6:{s:2:"id";s:6:"111741";s:10:"product_id";i:111741;s:4:"name";s:44:"Baštenski sto na rasklapanje 120x596x440 cm";s:12:"product_name";s:44:"Baštenski sto na rasklapanje 120x596x440 cm";s:3:"url";s:43:"bastenski-sto-na-rasklapanje-120x596x440-cm";s:4:"path";s:13:"/1/44/97/961/";}i:4;a:6:{s:2:"id";s:6:"108640";s:10:"product_id";i:108640;s:4:"name";s:46:"Sto Plastični Okrugli 800x800xH740x50 mm Haus";s:12:"product_name";s:46:"Sto Plastični Okrugli 800x800xH740x50 mm Haus";s:3:"url";s:45:"sto-plasticni-okrugli-800x800xh740x50-mm-haus";s:4:"path";s:13:"/1/44/97/961/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1790352407 , 'cache_tree_oidl_961' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:5:{i:0;a:6:{s:2:\"id\";s:5:\"64535\";s:10:\"product_id\";i:64535;s:4:\"name\";s:38:\"Sto plastični 760x500xH580x48 mm Haus\";s:12:\"product_name\";s:38:\"Sto plastični 760x500xH580x48 mm Haus\";s:3:\"url\";s:37:\"sto-plasticni-760x500xh580x48-mm-haus\";s:4:\"path\";s:13:\"/1/44/97/961/\";}i:1;a:6:{s:2:\"id\";s:5:\"65324\";s:10:\"product_id\";i:65324;s:4:\"name\";s:54:\"Baštenski sto okrugli 80cm crno kaljeno staklo Milano\";s:12:\"product_name\";s:54:\"Baštenski sto okrugli 80cm crno kaljeno staklo Milano\";s:3:\"url\";s:53:\"bastenski-sto-okrugli-80cm-crno-kaljeno-staklo-milano\";s:4:\"path\";s:13:\"/1/44/97/961/\";}i:2;a:6:{s:2:\"id\";s:5:\"59541\";s:10:\"product_id\";i:59541;s:4:\"name\";s:36:\"Stočić Ø60X70cm metal/staklo crni\";s:12:\"product_name\";s:36:\"Stočić Ø60X70cm metal/staklo crni\";s:3:\"url\";s:31:\"stocic-60x70cm-metalstaklo-crni\";s:4:\"path\";s:13:\"/1/44/97/961/\";}i:3;a:6:{s:2:\"id\";s:6:\"111741\";s:10:\"product_id\";i:111741;s:4:\"name\";s:44:\"Baštenski sto na rasklapanje 120x596x440 cm\";s:12:\"product_name\";s:44:\"Baštenski sto na rasklapanje 120x596x440 cm\";s:3:\"url\";s:43:\"bastenski-sto-na-rasklapanje-120x596x440-cm\";s:4:\"path\";s:13:\"/1/44/97/961/\";}i:4;a:6:{s:2:\"id\";s:6:\"108640\";s:10:\"product_id\";i:108640;s:4:\"name\";s:46:\"Sto Plastični Okrugli 800x800xH740x50 mm Haus\";s:12:\"product_name\";s:46:\"Sto Plastični Okrugli 800x800xH740x50 mm Haus\";s:3:\"url\";s:45:\"sto-plasticni-okrugli-800x800xh740x50-mm-haus\";s:4:\"path\";s:13:\"/1/44/97/961/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
6
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
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 = 97 and active = 1 ;
Copy
7
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 :
[
1790352407
"cache_tree_oidl_97 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_97' );
Copy
8
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
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 = 44 and active = 1 ;
Copy
9
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 :
[
1790352407
"cache_tree_oidl_44 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_44' );
Copy
10
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
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 = 1 and active = 1 ;
Copy
11
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 :
[
1790352407
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
12
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
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 = 1 and active = 1 ;
Copy
13
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 :
[
1790352407
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
14
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
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 = 44 and active = 1 ;
Copy
15
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 :
[
1790352407
"cache_tree_oidl_44 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_44' );
Copy
16
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
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 = 1 and active = 1 ;
Copy
17
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 :
[
1790352407
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
18
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
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 = 1 and active = 1 ;
Copy
19
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 :
[
1790352407
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790352407 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
20
0.08 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 "
]
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = 1 and web_page IN ('kategorije' , 'ostale' );
Copy