1
2.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 ,
cache_tree , cache_tree_aim , show_eponuda
FROM kategorije
WHERE category_name_seo = ? and active = 1
Parameters :
[
"ruteri-i-svicevi "
]
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 = 'ruteri-i-svicevi' and active = 1 ;
Copy
2
0.30 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 :
[
1790349956
"cache_tree_oidl_1020 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1020' );
Copy
3
0.41 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
Parameters :
[
1020
1020
]
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 = 1020 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 = 1020 and c1 . active = 1 and c2 . show_category = 1 )
ORDER BY category_name ;
Copy
4
9.51 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 => 1790349956
0 => "cache_tree_oidl_1020 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:5:{i:0;a:6:{s:2:"id";s:6:"115660";s:10:"product_id";i:115660;s:4:"name";s:50:"TP-Link TL-SF1005D,5-Port 10/100Mbps Desktop Switc";s:12:"product_name";s:50:"TP-Link TL-SF1005D,5-Port 10/100Mbps Desktop Switc";s:3:"url";s:48:"tp-link-tl-sf1005d5-port-10100mbps-desktop-switc";s:4:"path";s:16:"/1/172/205/1020/";}i:1;a:6:{s:2:"id";s:6:"115600";s:10:"product_id";i:115600;s:4:"name";s:56:"TP-Link TL-WN722N Wi-Fi USB adapter sa 1 antenom 150Mbsp";s:12:"product_name";s:56:"TP-Link TL-WN722N Wi-Fi USB adapter sa 1 antenom 150Mbsp";s:3:"url";s:56:"tp-link-tl-wn722n-wi-fi-usb-adapter-sa-1-antenom-150mbsp";s:4:"path";s:16:"/1/172/205/1020/";}i:2;a:6:{s:2:"id";s:5:"95192";s:10:"product_id";i:95192;s:4:"name";s:89:"Tenda N301 Wireless N300 Ruter, WISP/univ. repeater/WDS-bridge/client+AP/WPS, 3L/1W 2x5dB";s:12:"product_name";s:89:"Tenda N301 Wireless N300 Ruter, WISP/univ. repeater/WDS-bridge/client+AP/WPS, 3L/1W 2x5dB";s:3:"url";s:79:"tenda-n301-wireles-n300-ruter-wispuniv-repeaterwds-bridgeclientapwps-3l1w-2x5db";s:4:"path";s:16:"/1/172/205/1020/";}i:3;a:6:{s:2:"id";s:6:"115641";s:10:"product_id";i:115641;s:4:"name";s:48:"TP-Link LS1008, 8-Port 10/100Mbps Desktop Switch";s:12:"product_name";s:48:"TP-Link LS1008, 8-Port 10/100Mbps Desktop Switch";s:3:"url";s:46:"tp-link-ls1008-8-port-10100mbps-desktop-switch";s:4:"path";s:16:"/1/172/205/1020/";}i:4;a:6:{s:2:"id";s:6:"113816";s:10:"product_id";i:113816;s:4:"name";s:50:"TP-Link TL-SF1008D,8-Port 10/100Mbps Desktop Switc";s:12:"product_name";s:50:"TP-Link TL-SF1008D,8-Port 10/100Mbps Desktop Switc";s:3:"url";s:48:"tp-link-tl-sf1008d8-port-10100mbps-desktop-switc";s:4:"path";s:16:"/1/172/205/1020/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1790349956 , 'cache_tree_oidl_1020' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:5:{i:0;a:6:{s:2:\"id\";s:6:\"115660\";s:10:\"product_id\";i:115660;s:4:\"name\";s:50:\"TP-Link TL-SF1005D,5-Port 10/100Mbps Desktop Switc\";s:12:\"product_name\";s:50:\"TP-Link TL-SF1005D,5-Port 10/100Mbps Desktop Switc\";s:3:\"url\";s:48:\"tp-link-tl-sf1005d5-port-10100mbps-desktop-switc\";s:4:\"path\";s:16:\"/1/172/205/1020/\";}i:1;a:6:{s:2:\"id\";s:6:\"115600\";s:10:\"product_id\";i:115600;s:4:\"name\";s:56:\"TP-Link TL-WN722N Wi-Fi USB adapter sa 1 antenom 150Mbsp\";s:12:\"product_name\";s:56:\"TP-Link TL-WN722N Wi-Fi USB adapter sa 1 antenom 150Mbsp\";s:3:\"url\";s:56:\"tp-link-tl-wn722n-wi-fi-usb-adapter-sa-1-antenom-150mbsp\";s:4:\"path\";s:16:\"/1/172/205/1020/\";}i:2;a:6:{s:2:\"id\";s:5:\"95192\";s:10:\"product_id\";i:95192;s:4:\"name\";s:89:\"Tenda N301 Wireless N300 Ruter, WISP/univ. repeater/WDS-bridge/client+AP/WPS, 3L/1W 2x5dB\";s:12:\"product_name\";s:89:\"Tenda N301 Wireless N300 Ruter, WISP/univ. repeater/WDS-bridge/client+AP/WPS, 3L/1W 2x5dB\";s:3:\"url\";s:79:\"tenda-n301-wireles-n300-ruter-wispuniv-repeaterwds-bridgeclientapwps-3l1w-2x5db\";s:4:\"path\";s:16:\"/1/172/205/1020/\";}i:3;a:6:{s:2:\"id\";s:6:\"115641\";s:10:\"product_id\";i:115641;s:4:\"name\";s:48:\"TP-Link LS1008, 8-Port 10/100Mbps Desktop Switch\";s:12:\"product_name\";s:48:\"TP-Link LS1008, 8-Port 10/100Mbps Desktop Switch\";s:3:\"url\";s:46:\"tp-link-ls1008-8-port-10100mbps-desktop-switch\";s:4:\"path\";s:16:\"/1/172/205/1020/\";}i:4;a:6:{s:2:\"id\";s:6:\"113816\";s:10:\"product_id\";i:113816;s:4:\"name\";s:50:\"TP-Link TL-SF1008D,8-Port 10/100Mbps Desktop Switc\";s:12:\"product_name\";s:50:\"TP-Link TL-SF1008D,8-Port 10/100Mbps Desktop Switc\";s:3:\"url\";s:48:\"tp-link-tl-sf1008d8-port-10100mbps-desktop-switc\";s:4:\"path\";s:16:\"/1/172/205/1020/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
5
0.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 ,
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 = 205 and active = 1 ;
Copy
6
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 :
[
1790349956
"cache_tree_oidl_205 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_205' );
Copy
7
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 = 172 and active = 1 ;
Copy
8
0.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 :
[
1790349956
"cache_tree_oidl_172 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_172' );
Copy
9
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
10
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 :
[
1790349956
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
11
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
12
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 :
[
1790349956
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
13
0.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 ,
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 = 172 and active = 1 ;
Copy
14
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 :
[
1790349956
"cache_tree_oidl_172 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_172' );
Copy
15
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
16
0.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 :
[
1790349956
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
17
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
18
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 :
[
1790349956
"cache_tree_oidl_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790349956 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_oidl_1' );
Copy
19
0.36 ms
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = ? and web_page IN (? , ? )
Parameters :
[
1
"kategorije "
"ostale "
]
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = 1 and web_page IN ('kategorije' , 'ostale' );
Copy