1
3.79 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 :
[
"punjaci-baterija "
]
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 = 'punjaci-baterija' and active = 1 ;
Copy
2
0.32 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 :
[
1780705566
"cache_tree_aim_909 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_909' );
Copy
3
9.51 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780705566
"cache_tree_aim_909 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780705566 AND item_id IN ('cache_tree_aim_909' );
Copy
4
0.76 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 = 909 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 = 909 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ;
Copy
5
10.70 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 => 1780705566
0 => "cache_tree_aim_909 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:4:{i:0;a:6:{s:2:"id";s:6:"111404";s:10:"product_id";i:111404;s:4:"name";s:45:"Punjač baterija NiMH / NiCd XACT 250 ANSMANN";s:12:"product_name";s:45:"Punjač baterija NiMH / NiCd XACT 250 ANSMANN";s:3:"url";s:42:"punjac-baterija-nimh-nicd-xact-250-ansmann";s:4:"path";s:15:"/1/169/318/909/";}i:1;a:6:{s:2:"id";s:6:"111407";s:10:"product_id";i:111407;s:4:"name";s:52:"Punjač baterija NiMH / NiCd POWERLINE 5 PRO Ansmann";s:12:"product_name";s:52:"Punjač baterija NiMH / NiCd POWERLINE 5 PRO Ansmann";s:3:"url";s:49:"punjac-baterija-nimh-nicd-powerline-5-pro-ansmann";s:4:"path";s:15:"/1/169/318/909/";}i:2;a:6:{s:2:"id";s:6:"111406";s:10:"product_id";i:111406;s:4:"name";s:50:"Punjač baterija NiMH / NiCd ENERGY 8 plus ANSMANN";s:12:"product_name";s:50:"Punjač baterija NiMH / NiCd ENERGY 8 plus ANSMANN";s:3:"url";s:47:"punjac-baterija-nimh-nicd-energy-8-plus-ansmann";s:4:"path";s:15:"/1/169/318/909/";}i:3;a:6:{s:2:"id";s:6:"111405";s:10:"product_id";i:111405;s:4:"name";s:51:"Punjač baterija NiMH / NiCd ENERGY 16 plus ANSMANN";s:12:"product_name";s:51:"Punjač baterija NiMH / NiCd ENERGY 16 plus ANSMANN";s:3:"url";s:48:"punjac-baterija-nimh-nicd-energy-16-plus-ansmann";s:4:"path";s:15:"/1/169/318/909/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780705566 , 'cache_tree_aim_909' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:4:{i:0;a:6:{s:2:\"id\";s:6:\"111404\";s:10:\"product_id\";i:111404;s:4:\"name\";s:45:\"Punjač baterija NiMH / NiCd XACT 250 ANSMANN\";s:12:\"product_name\";s:45:\"Punjač baterija NiMH / NiCd XACT 250 ANSMANN\";s:3:\"url\";s:42:\"punjac-baterija-nimh-nicd-xact-250-ansmann\";s:4:\"path\";s:15:\"/1/169/318/909/\";}i:1;a:6:{s:2:\"id\";s:6:\"111407\";s:10:\"product_id\";i:111407;s:4:\"name\";s:52:\"Punjač baterija NiMH / NiCd POWERLINE 5 PRO Ansmann\";s:12:\"product_name\";s:52:\"Punjač baterija NiMH / NiCd POWERLINE 5 PRO Ansmann\";s:3:\"url\";s:49:\"punjac-baterija-nimh-nicd-powerline-5-pro-ansmann\";s:4:\"path\";s:15:\"/1/169/318/909/\";}i:2;a:6:{s:2:\"id\";s:6:\"111406\";s:10:\"product_id\";i:111406;s:4:\"name\";s:50:\"Punjač baterija NiMH / NiCd ENERGY 8 plus ANSMANN\";s:12:\"product_name\";s:50:\"Punjač baterija NiMH / NiCd ENERGY 8 plus ANSMANN\";s:3:\"url\";s:47:\"punjac-baterija-nimh-nicd-energy-8-plus-ansmann\";s:4:\"path\";s:15:\"/1/169/318/909/\";}i:3;a:6:{s:2:\"id\";s:6:\"111405\";s:10:\"product_id\";i:111405;s:4:\"name\";s:51:\"Punjač baterija NiMH / NiCd ENERGY 16 plus ANSMANN\";s:12:\"product_name\";s:51:\"Punjač baterija NiMH / NiCd ENERGY 16 plus ANSMANN\";s:3:\"url\";s:48:\"punjac-baterija-nimh-nicd-energy-16-plus-ansmann\";s:4:\"path\";s:15:\"/1/169/318/909/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
6
0.47 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 = 318 and active = 1 ;
Copy
7
0.39 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 :
[
1780705566
"cache_tree_aim_318 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_318' );
Copy
8
0.37 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 = 169 and active = 1 ;
Copy
9
0.34 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 :
[
1780705566
"cache_tree_aim_169 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_169' );
Copy
10
0.41 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.34 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 :
[
1780705566
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
12
0.42 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.31 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 :
[
1780705566
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
14
0.29 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 = 169 and active = 1 ;
Copy
15
0.18 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 :
[
1780705566
"cache_tree_aim_169 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_169' );
Copy
16
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
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.18 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 :
[
1780705566
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
18
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
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.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 :
[
1780705566
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705566 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy