1
5.68 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 :
[
"scart-kablovi "
]
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 = 'scart-kablovi' and active = 1 ; Copy
2
43.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 :
[
1780699945
"cache_tree_aim_872 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_872' ); Copy
3
21.29 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780699945
"cache_tree_aim_872 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780699945 AND item_id IN ('cache_tree_aim_872' ); Copy
4
0.43 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 = 872 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 = 872 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ; Copy
5
24.40 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 => 1780699945
0 => "cache_tree_aim_872 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:3:{i:0;a:6:{s:2:"id";s:5:"30169";s:10:"product_id";i:30169;s:4:"name";s:23:"Video kabl SCART48 1.5m";s:12:"product_name";s:23:"Video kabl SCART48 1.5m";s:3:"url";s:22:"video-kabl-scart48-15m";s:4:"path";s:18:"/1/29/311/869/872/";}i:1;a:6:{s:2:"id";s:5:"30170";s:10:"product_id";i:30170;s:4:"name";s:22:"Video kabl SCART48/5 m";s:12:"product_name";s:22:"Video kabl SCART48/5 m";s:3:"url";s:21:"video-kabl-scart485-m";s:4:"path";s:18:"/1/29/311/869/872/";}i:2;a:6:{s:2:"id";s:5:"30171";s:10:"product_id";i:30171;s:4:"name";s:24:"Video kabel SCART48/10 m";s:12:"product_name";s:24:"Video kabel SCART48/10 m";s:3:"url";s:23:"video-kabel-scart4810-m";s:4:"path";s:18:"/1/29/311/869/872/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780699945 , 'cache_tree_aim_872' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:3:{i:0;a:6:{s:2:\"id\";s:5:\"30169\";s:10:\"product_id\";i:30169;s:4:\"name\";s:23:\"Video kabl SCART48 1.5m\";s:12:\"product_name\";s:23:\"Video kabl SCART48 1.5m\";s:3:\"url\";s:22:\"video-kabl-scart48-15m\";s:4:\"path\";s:18:\"/1/29/311/869/872/\";}i:1;a:6:{s:2:\"id\";s:5:\"30170\";s:10:\"product_id\";i:30170;s:4:\"name\";s:22:\"Video kabl SCART48/5 m\";s:12:\"product_name\";s:22:\"Video kabl SCART48/5 m\";s:3:\"url\";s:21:\"video-kabl-scart485-m\";s:4:\"path\";s:18:\"/1/29/311/869/872/\";}i:2;a:6:{s:2:\"id\";s:5:\"30171\";s:10:\"product_id\";i:30171;s:4:\"name\";s:24:\"Video kabel SCART48/10 m\";s:12:\"product_name\";s:24:\"Video kabel SCART48/10 m\";s:3:\"url\";s:23:\"video-kabel-scart4810-m\";s:4:\"path\";s:18:\"/1/29/311/869/872/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time ); Copy
6
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 = 869 and active = 1 ; Copy
7
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 :
[
1780699945
"cache_tree_aim_869 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_869' ); 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 = 311 and active = 1 ; Copy
9
23.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 :
[
1780699945
"cache_tree_aim_311 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_311' ); Copy
10
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 = 29 and active = 1 ; Copy
11
0.11 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 :
[
1780699945
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
12
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 = 1 and active = 1 ; Copy
13
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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
14
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
15
0.13 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
16
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 = 29 and active = 1 ; Copy
17
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 :
[
1780699945
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
18
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
19
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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
20
0.16 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
21
0.12 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
22
0.16 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 = 311 and active = 1 ; Copy
23
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 :
[
1780699945
"cache_tree_aim_311 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_311' ); Copy
24
0.16 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 = 29 and active = 1 ; Copy
25
0.13 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 :
[
1780699945
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
26
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
27
0.12 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
28
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
29
0.11 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
30
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 = 29 and active = 1 ; Copy
31
0.12 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 :
[
1780699945
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
32
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
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
33
0.12 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
34
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
35
0.12 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 :
[
1780699945
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699945 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
36
0.31 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 = '' ) AND fl_alat = 1
SELECT COUNT (* ) AS broj_proizvoda
FROM proizvodi
WHERE category_id = 872 AND show_product = 1 AND active = 1 AND (copy_from_id is NULL OR copy_from_id = '' ) AND fl_alat = 1 ; Copy