1
0.30 ms
SELECT id , brand_name , brand_name_seo , brand_description , brand_image , meta_title , meta_description , meta_keywords , num_of_products , num_of_products_aim , img_size
FROM proizvodjaci
WHERE id = ? and active = 1
SELECT id , brand_name , brand_name_seo , brand_description , brand_image , meta_title , meta_description , meta_keywords , num_of_products , num_of_products_aim , img_size
FROM proizvodjaci
WHERE id = 130 and active = 1 ;
Copy
2
0.31 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 = 876 and active = 1 ;
Copy
3
0.14 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 :
[
1780705398
"cache_tree_aim_876 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_876' );
Copy
4
15.92 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780705398
"cache_tree_aim_876 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780705398 AND item_id IN ('cache_tree_aim_876' );
Copy
5
0.37 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 = 876 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 = 876 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ;
Copy
6
8.02 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 => 1780705398
0 => "cache_tree_aim_876 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:0:{}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780705398 , 'cache_tree_aim_876' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:0:{}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time );
Copy
7
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 = 311 and active = 1 ;
Copy
8
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 :
[
1780705398
"cache_tree_aim_311 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_311' );
Copy
9
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 = 29 and active = 1 ;
Copy
10
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 :
[
1780705398
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' );
Copy
11
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
12
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 :
[
1780705398
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
13
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
14
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 :
[
1780705398
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
15
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 = 29 and active = 1 ;
Copy
16
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 :
[
1780705398
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' );
Copy
17
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 = 1 and active = 1 ;
Copy
18
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 :
[
1780705398
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
19
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
20
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 :
[
1780705398
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780705398 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' );
Copy
21
0.09 ms
SELECT p . id id , p . product_id , p . name file_name , 1 file_type
FROM proizvodi_pdf p
WHERE p . active = 1 AND p . product_id = ?
ORDER BY file_type
SELECT p . id id , p . product_id , p . name file_name , 1 file_type
FROM proizvodi_pdf p
WHERE p . active = 1 AND p . product_id = 29147
ORDER BY file_type ;
Copy
22
0.07 ms
SELECT p . share_link
FROM proizvodi_filmovi p
WHERE p . product_id = ? AND p . share_link ! = '' AND p . active = 1
SELECT p . share_link
FROM proizvodi_filmovi p
WHERE p . product_id = 29147 AND p . share_link ! = '' AND p . active = 1 ;
Copy
23
0.06 ms
SELECT *
FROM proizvodi_rejting_star
WHERE product_id = ?
SELECT *
FROM proizvodi_rejting_star
WHERE product_id = 29147 ;
Copy
24
0.08 ms
SELECT *
FROM proizvodi_komentari
WHERE id_proizvoda = ? and active = 1
ORDER BY vreme DESC
SELECT *
FROM proizvodi_komentari
WHERE id_proizvoda = 29147 and active = 1
ORDER BY vreme DESC ;
Copy
25
0.12 ms
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = ? and web_page IN (? , ? )
Parameters :
[
2
"proizvodi "
"ostale "
]
SELECT page_title , page_meta_description , page_meta_keywords , web_page
FROM website_tags
WHERE website = 2 and web_page IN ('proizvodi' , 'ostale' );
Copy
26
0.14 ms
SELECT k . category_name , k . category_name_seo , p . product_name , pl . id
FROM kategorije k , proizvodi p , proizvodi_oprema pl
WHERE p . id = pl . product_id AND p . id = ? AND pl . product_link_category_id = k . id
AND p . active = 1 AND p . show_product = 1 AND k . active = 1 AND k . show_category = 1
ORDER BY pl . id
SELECT k . category_name , k . category_name_seo , p . product_name , pl . id
FROM kategorije k , proizvodi p , proizvodi_oprema pl
WHERE p . id = pl . product_id AND p . id = 29147 AND pl . product_link_category_id = k . id
AND p . active = 1 AND p . show_product = 1 AND k . active = 1 AND k . show_category = 1
ORDER BY pl . id ;
Copy