1
2.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 ,
cache_tree , cache_tree_aim , show_eponuda
FROM kategorije
WHERE category_name_seo = ? and active = 1
Parameters :
[
"umetnost "
]
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 = 'umetnost' and active = 1 ;
Copy
2
0.28 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 :
[
1790347946
"cache_tree_oidl_85 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790347946 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_85' );
Copy
3
0.35 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 = 85 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 = 85 and c1 . active = 1 and c2 . show_category = 1 )
ORDER BY category_name ;
Copy
4
10.98 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 => 1790347946
0 => "cache_tree_oidl_85 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"10415";s:10:"product_id";i:10415;s:4:"name";s:24:"Piramida onix visina 8cm";s:12:"product_name";s:24:"Piramida onix visina 8cm";s:3:"url";s:24:"piramida-onix-visina-8cm";s:4:"path";s:9:"/1/29/85/";}i:1;a:6:{s:2:"id";s:5:"10414";s:10:"product_id";i:10414;s:4:"name";s:16:"Sova visina 10cm";s:12:"product_name";s:16:"Sova visina 10cm";s:3:"url";s:16:"sova-visina-10cm";s:4:"path";s:9:"/1/29/85/";}i:2;a:6:{s:2:"id";s:5:"10411";s:10:"product_id";i:10411;s:4:"name";s:14:"Gvozdeni jarac";s:12:"product_name";s:14:"Gvozdeni jarac";s:3:"url";s:14:"gvozdeni-jarac";s:4:"path";s:9:"/1/29/85/";}i:3;a:6:{s:2:"id";s:5:"10408";s:10:"product_id";i:10408;s:4:"name";s:13:"Figurina 17cm";s:12:"product_name";s:13:"Figurina 17cm";s:3:"url";s:13:"figurina-17cm";s:4:"path";s:9:"/1/29/85/";}i:4;a:6:{s:2:"id";s:5:"10413";s:10:"product_id";i:10413;s:4:"name";s:11:"Gips figura";s:12:"product_name";s:11:"Gips figura";s:3:"url";s:11:"gips-figura";s:4:"path";s:9:"/1/29/85/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1790347946 , 'cache_tree_oidl_85' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:5:{i:0;a:6:{s:2:\"id\";s:5:\"10415\";s:10:\"product_id\";i:10415;s:4:\"name\";s:24:\"Piramida onix visina 8cm\";s:12:\"product_name\";s:24:\"Piramida onix visina 8cm\";s:3:\"url\";s:24:\"piramida-onix-visina-8cm\";s:4:\"path\";s:9:\"/1/29/85/\";}i:1;a:6:{s:2:\"id\";s:5:\"10414\";s:10:\"product_id\";i:10414;s:4:\"name\";s:16:\"Sova visina 10cm\";s:12:\"product_name\";s:16:\"Sova visina 10cm\";s:3:\"url\";s:16:\"sova-visina-10cm\";s:4:\"path\";s:9:\"/1/29/85/\";}i:2;a:6:{s:2:\"id\";s:5:\"10411\";s:10:\"product_id\";i:10411;s:4:\"name\";s:14:\"Gvozdeni jarac\";s:12:\"product_name\";s:14:\"Gvozdeni jarac\";s:3:\"url\";s:14:\"gvozdeni-jarac\";s:4:\"path\";s:9:\"/1/29/85/\";}i:3;a:6:{s:2:\"id\";s:5:\"10408\";s:10:\"product_id\";i:10408;s:4:\"name\";s:13:\"Figurina 17cm\";s:12:\"product_name\";s:13:\"Figurina 17cm\";s:3:\"url\";s:13:\"figurina-17cm\";s:4:\"path\";s:9:\"/1/29/85/\";}i:4;a:6:{s:2:\"id\";s:5:\"10413\";s:10:\"product_id\";i:10413;s:4:\"name\";s:11:\"Gips figura\";s:12:\"product_name\";s:11:\"Gips figura\";s:3:\"url\";s:11:\"gips-figura\";s:4:\"path\";s:9:\"/1/29/85/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
5
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
6
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 :
[
1790347946
"cache_tree_oidl_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790347946 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_29' );
Copy
7
0.19 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
8
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 :
[
1790347946
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790347946 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
9
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
10
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 :
[
1790347946
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790347946 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
11
0.33 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 = '' )
SELECT COUNT (* ) AS broj_proizvoda
FROM proizvodi
WHERE category_id = 85 AND show_product = 1 AND active = 1 AND (copy_from_id is NULL OR copy_from_id = '' );
Copy