1
2.23 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 :
[
"lanci-i-macevi "
]
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 = 'lanci-i-macevi' and active = 1 ;
Copy
2
0.21 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 :
[
1780954042
"cache_tree_aim_152 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_152' );
Copy
3
28.93 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780954042
"cache_tree_aim_152 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780954042 AND item_id IN ('cache_tree_aim_152' );
Copy
4
0.26 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 = 152 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 = 152 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ;
Copy
5
8.04 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 => 1780954042
0 => "cache_tree_aim_152 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:5:"92547";s:10:"product_id";i:92547;s:4:"name";s:40:"Oregon Lanac testere 3/8, 1,3MM, 20 zuba";s:12:"product_name";s:40:"Oregon Lanac testere 3/8, 1,3MM, 20 zuba";s:3:"url";s:36:"oregon-lanac-testere-38-13mm-20-zuba";s:4:"path";s:13:"/1/21/46/152/";}i:1;a:6:{s:2:"id";s:5:"91449";s:10:"product_id";i:91449;s:4:"name";s:36:"Rezervni mač za GC-EC 750 T Einhell";s:12:"product_name";s:36:"Rezervni mač za GC-EC 750 T Einhell";s:3:"url";s:35:"rezervni-mac-za-gc-ec-750-t-einhell";s:4:"path";s:13:"/1/21/46/152/";}i:2;a:6:{s:2:"id";s:6:"117994";s:10:"product_id";i:117994;s:4:"name";s:63:"Lanac za električne testere 3/8".050" (1.3mm) 57 140104 3347OM";s:12:"product_name";s:63:"Lanac za električne testere 3/8".050" (1.3mm) 57 140104 3347OM";s:3:"url";s:55:"lanac-za-elektricne-testere-38050-13mm-57-140104-3347om";s:4:"path";s:13:"/1/21/46/152/";}i:3;a:6:{s:2:"id";s:6:"117978";s:10:"product_id";i:117978;s:4:"name";s:58:"Lanac motorne testere RD 3/8 link 56 (1.3mm) 140103 2329OM";s:12:"product_name";s:58:"Lanac motorne testere RD 3/8 link 56 (1.3mm) 140103 2329OM";s:3:"url";s:54:"lanac-motorne-testere-rd-38-link-56-13mm-140103-2329om";s:4:"path";s:13:"/1/21/46/152/";}i:4;a:6:{s:2:"id";s:5:"82997";s:10:"product_id";i:82997;s:4:"name";s:74:"Lanac za testeru 3/8" 1.3mm ( VGS 12, VGS 12S, VGS 260S ) 91VXL045E Oregon";s:12:"product_name";s:74:"Lanac za testeru 3/8" 1.3mm ( VGS 12, VGS 12S, VGS 260S ) 91VXL045E Oregon";s:3:"url";s:65:"lanac-za-testeru-38-13mm-vgs-12-vgs-12s-vgs-260s-91vxl045e-oregon";s:4:"path";s:13:"/1/21/46/152/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780954042 , 'cache_tree_aim_152' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:5:{i:0;a:6:{s:2:\"id\";s:5:\"92547\";s:10:\"product_id\";i:92547;s:4:\"name\";s:40:\"Oregon Lanac testere 3/8, 1,3MM, 20 zuba\";s:12:\"product_name\";s:40:\"Oregon Lanac testere 3/8, 1,3MM, 20 zuba\";s:3:\"url\";s:36:\"oregon-lanac-testere-38-13mm-20-zuba\";s:4:\"path\";s:13:\"/1/21/46/152/\";}i:1;a:6:{s:2:\"id\";s:5:\"91449\";s:10:\"product_id\";i:91449;s:4:\"name\";s:36:\"Rezervni mač za GC-EC 750 T Einhell\";s:12:\"product_name\";s:36:\"Rezervni mač za GC-EC 750 T Einhell\";s:3:\"url\";s:35:\"rezervni-mac-za-gc-ec-750-t-einhell\";s:4:\"path\";s:13:\"/1/21/46/152/\";}i:2;a:6:{s:2:\"id\";s:6:\"117994\";s:10:\"product_id\";i:117994;s:4:\"name\";s:63:\"Lanac za električne testere 3/8\".050\" (1.3mm) 57 140104 3347OM\";s:12:\"product_name\";s:63:\"Lanac za električne testere 3/8\".050\" (1.3mm) 57 140104 3347OM\";s:3:\"url\";s:55:\"lanac-za-elektricne-testere-38050-13mm-57-140104-3347om\";s:4:\"path\";s:13:\"/1/21/46/152/\";}i:3;a:6:{s:2:\"id\";s:6:\"117978\";s:10:\"product_id\";i:117978;s:4:\"name\";s:58:\"Lanac motorne testere RD 3/8 link 56 (1.3mm) 140103 2329OM\";s:12:\"product_name\";s:58:\"Lanac motorne testere RD 3/8 link 56 (1.3mm) 140103 2329OM\";s:3:\"url\";s:54:\"lanac-motorne-testere-rd-38-link-56-13mm-140103-2329om\";s:4:\"path\";s:13:\"/1/21/46/152/\";}i:4;a:6:{s:2:\"id\";s:5:\"82997\";s:10:\"product_id\";i:82997;s:4:\"name\";s:74:\"Lanac za testeru 3/8\" 1.3mm ( VGS 12, VGS 12S, VGS 260S ) 91VXL045E Oregon\";s:12:\"product_name\";s:74:\"Lanac za testeru 3/8\" 1.3mm ( VGS 12, VGS 12S, VGS 260S ) 91VXL045E Oregon\";s:3:\"url\";s:65:\"lanac-za-testeru-38-13mm-vgs-12-vgs-12s-vgs-260s-91vxl045e-oregon\";s:4:\"path\";s:13:\"/1/21/46/152/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
6
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 = 46 and active = 1 ;
Copy
7
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 :
[
1780954042
"cache_tree_aim_46 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_46' );
Copy
8
0.10 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 = 21 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 :
[
1780954042
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' );
Copy
10
0.07 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 :
[
1780954042
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
12
0.06 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.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 :
[
1780954042
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
14
0.06 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 = 21 and active = 1 ;
Copy
15
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 :
[
1780954042
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' );
Copy
16
0.06 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 :
[
1780954042
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
18
0.05 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 :
[
1780954042
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780954042 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
20
0.10 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