1
2.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 ,
cache_tree , cache_tree_aim , show_eponuda
FROM kategorije
WHERE category_name_seo = ? and active = 1
Parameters :
[
"sredstva-za-pranje-vozila "
]
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 = 'sredstva-za-pranje-vozila' and active = 1 ;
Copy
2
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 :
[
1780960060
"cache_tree_aim_686 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780960060 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_686' );
Copy
3
9.16 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780960060
"cache_tree_aim_686 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780960060 AND item_id IN ('cache_tree_aim_686' );
Copy
4
0.32 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
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 = 686 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 = 686 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ;
Copy
5
8.47 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 => 1780960060
0 => "cache_tree_aim_686 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"44384";s:10:"product_id";i:44384;s:4:"name";s:32:"Tečni premaz za gume Gumix 1lit";s:12:"product_name";s:32:"Tečni premaz za gume Gumix 1lit";s:3:"url";s:31:"tecni-premaz-za-gume-gumix-1lit";s:4:"path";s:11:"/1/170/686/";}i:1;a:6:{s:2:"id";s:5:"44380";s:10:"product_id";i:44380;s:4:"name";s:58:"Sredstvo za čišćenje gume i plastike Aromatik sjaj 1lit";s:12:"product_name";s:58:"Sredstvo za čišćenje gume i plastike Aromatik sjaj 1lit";s:3:"url";s:55:"sredstvo-za-ciscenje-gume-i-plastike-aromatik-sjaj-1lit";s:4:"path";s:11:"/1/170/686/";}i:2;a:6:{s:2:"id";s:5:"96820";s:10:"product_id";i:96820;s:4:"name";s:69:"Karcher penušavo sredstvo za čišćenje RM 615, 6.295-743.0 1 litar";s:12:"product_name";s:69:"Karcher penušavo sredstvo za čišćenje RM 615, 6.295-743.0 1 litar";s:3:"url";s:62:"karcher-penusavo-sredstvo-za-ciscenje-rm-615-6295-7430-1-litar";s:4:"path";s:11:"/1/170/686/";}i:3;a:6:{s:2:"id";s:5:"96835";s:10:"product_id";i:96835;s:4:"name";s:57:"Karcher Odstranjivač insekata RM 618, 6.295-761.0 500 ml";s:12:"product_name";s:57:"Karcher Odstranjivač insekata RM 618, 6.295-761.0 500 ml";s:3:"url";s:53:"karcher-odstranjivac-insekata-rm-618-6295-7610-500-ml";s:4:"path";s:11:"/1/170/686/";}i:4;a:6:{s:2:"id";s:5:"56369";s:10:"product_id";i:56369;s:4:"name";s:43:"Gel za čišćenje stakla 3U1 500ML KARCHER";s:12:"product_name";s:43:"Gel za čišćenje stakla 3U1 500ML KARCHER";s:3:"url";s:40:"gel-za-ciscenje-stakla-3u1-500ml-karcher";s:4:"path";s:11:"/1/170/686/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780960060 , 'cache_tree_aim_686' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:5:{i:0;a:6:{s:2:\"id\";s:5:\"44384\";s:10:\"product_id\";i:44384;s:4:\"name\";s:32:\"Tečni premaz za gume Gumix 1lit\";s:12:\"product_name\";s:32:\"Tečni premaz za gume Gumix 1lit\";s:3:\"url\";s:31:\"tecni-premaz-za-gume-gumix-1lit\";s:4:\"path\";s:11:\"/1/170/686/\";}i:1;a:6:{s:2:\"id\";s:5:\"44380\";s:10:\"product_id\";i:44380;s:4:\"name\";s:58:\"Sredstvo za čišćenje gume i plastike Aromatik sjaj 1lit\";s:12:\"product_name\";s:58:\"Sredstvo za čišćenje gume i plastike Aromatik sjaj 1lit\";s:3:\"url\";s:55:\"sredstvo-za-ciscenje-gume-i-plastike-aromatik-sjaj-1lit\";s:4:\"path\";s:11:\"/1/170/686/\";}i:2;a:6:{s:2:\"id\";s:5:\"96820\";s:10:\"product_id\";i:96820;s:4:\"name\";s:69:\"Karcher penušavo sredstvo za čišćenje RM 615, 6.295-743.0 1 litar\";s:12:\"product_name\";s:69:\"Karcher penušavo sredstvo za čišćenje RM 615, 6.295-743.0 1 litar\";s:3:\"url\";s:62:\"karcher-penusavo-sredstvo-za-ciscenje-rm-615-6295-7430-1-litar\";s:4:\"path\";s:11:\"/1/170/686/\";}i:3;a:6:{s:2:\"id\";s:5:\"96835\";s:10:\"product_id\";i:96835;s:4:\"name\";s:57:\"Karcher Odstranjivač insekata RM 618, 6.295-761.0 500 ml\";s:12:\"product_name\";s:57:\"Karcher Odstranjivač insekata RM 618, 6.295-761.0 500 ml\";s:3:\"url\";s:53:\"karcher-odstranjivac-insekata-rm-618-6295-7610-500-ml\";s:4:\"path\";s:11:\"/1/170/686/\";}i:4;a:6:{s:2:\"id\";s:5:\"56369\";s:10:\"product_id\";i:56369;s:4:\"name\";s:43:\"Gel za čišćenje stakla 3U1 500ML KARCHER\";s:12:\"product_name\";s:43:\"Gel za čišćenje stakla 3U1 500ML KARCHER\";s:3:\"url\";s:40:\"gel-za-ciscenje-stakla-3u1-500ml-karcher\";s:4:\"path\";s:11:\"/1/170/686/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
6
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
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 = 170 and active = 1 ;
Copy
7
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 :
[
1780960060
"cache_tree_aim_170 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780960060 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_170' );
Copy
8
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
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
9
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 :
[
1780960060
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780960060 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
10
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
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.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 :
[
1780960060
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780960060 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
12
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
"kategorije "
"ostale "
]
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = 2 and web_page IN ('kategorije' , 'ostale' );
Copy