1
3.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 ,
cache_tree , cache_tree_aim , show_eponuda
FROM kategorije
WHERE category_name_seo = ? and active = 1
Parameters :
[
"kablovi-u-koturu "
]
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 = 'kablovi-u-koturu' and active = 1 ; Copy
2
0.42 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 :
[
1780704512
"cache_tree_aim_792 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_792' ); Copy
3
12.67 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780704512
"cache_tree_aim_792 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780704512 AND item_id IN ('cache_tree_aim_792' ); Copy
4
0.62 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 = 792 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 = 792 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ; Copy
5
16.03 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 => 1780704512
0 => "cache_tree_aim_792 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:3:{i:0;a:6:{s:2:"id";s:5:"40182";s:10:"product_id";i:40182;s:4:"name";s:46:"Koaksijalni kabel RG6U/LC 100m ( cena po 1 m )";s:12:"product_name";s:46:"Koaksijalni kabel RG6U/LC 100m ( cena po 1 m )";s:3:"url";s:41:"koaksijalni-kabel-rg6ulc-100m-cena-po-1-m";s:4:"path";s:14:"/1/29/311/792/";}i:1;a:6:{s:2:"id";s:5:"40183";s:10:"product_id";i:40183;s:4:"name";s:30:"Koaksijalni kabel RG6-32/BK 1m";s:12:"product_name";s:30:"Koaksijalni kabel RG6-32/BK 1m";s:3:"url";s:29:"koaksijalni-kabel-rg6-32bk-1m";s:4:"path";s:14:"/1/29/311/792/";}i:2;a:6:{s:2:"id";s:6:"117984";s:10:"product_id";i:117984;s:4:"name";s:41:"Motalica HV 10m bez kabla zatvorena 373OM";s:12:"product_name";s:41:"Motalica HV 10m bez kabla zatvorena 373OM";s:3:"url";s:41:"motalica-hv-10m-bez-kabla-zatvorena-373om";s:4:"path";s:14:"/1/29/311/792/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780704512 , 'cache_tree_aim_792' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:3:{i:0;a:6:{s:2:\"id\";s:5:\"40182\";s:10:\"product_id\";i:40182;s:4:\"name\";s:46:\"Koaksijalni kabel RG6U/LC 100m ( cena po 1 m )\";s:12:\"product_name\";s:46:\"Koaksijalni kabel RG6U/LC 100m ( cena po 1 m )\";s:3:\"url\";s:41:\"koaksijalni-kabel-rg6ulc-100m-cena-po-1-m\";s:4:\"path\";s:14:\"/1/29/311/792/\";}i:1;a:6:{s:2:\"id\";s:5:\"40183\";s:10:\"product_id\";i:40183;s:4:\"name\";s:30:\"Koaksijalni kabel RG6-32/BK 1m\";s:12:\"product_name\";s:30:\"Koaksijalni kabel RG6-32/BK 1m\";s:3:\"url\";s:29:\"koaksijalni-kabel-rg6-32bk-1m\";s:4:\"path\";s:14:\"/1/29/311/792/\";}i:2;a:6:{s:2:\"id\";s:6:\"117984\";s:10:\"product_id\";i:117984;s:4:\"name\";s:41:\"Motalica HV 10m bez kabla zatvorena 373OM\";s:12:\"product_name\";s:41:\"Motalica HV 10m bez kabla zatvorena 373OM\";s:3:\"url\";s:41:\"motalica-hv-10m-bez-kabla-zatvorena-373om\";s:4:\"path\";s:14:\"/1/29/311/792/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time ); Copy
6
0.44 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
7
0.36 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 :
[
1780704512
"cache_tree_aim_311 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_311' ); Copy
8
0.32 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
9
0.27 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 :
[
1780704512
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
10
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
11
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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
12
0.24 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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
14
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
15
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 :
[
1780704512
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
16
0.21 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.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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
18
0.24 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.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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
20
0.31 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
21
0.47 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 = 792 and active = 1 ; Copy
22
0.34 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 :
[
1780704512
"cache_tree_aim_792 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_792' ); Copy
23
0.38 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
24
0.31 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 :
[
1780704512
"cache_tree_aim_311 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_311' ); Copy
25
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 = 29 and active = 1 ; Copy
26
0.34 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 :
[
1780704512
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
27
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 = 1 and active = 1 ; Copy
28
0.35 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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
29
0.27 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
30
0.25 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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
31
0.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 ,
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
32
0.25 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 :
[
1780704512
"cache_tree_aim_29 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_29' ); Copy
33
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 = 1 and active = 1 ; Copy
34
0.27 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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
35
0.28 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
36
0.29 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 :
[
1780704512
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
37
0.80 ms
SELECT COUNT (p . id ) broj_proizvoda , b . id AS brand_id , b . brand_name , brand_image
FROM proizvodi p , proizvodjaci b
WHERE p . brand_id = b . id
AND p . active = 1 AND p . show_product = 1 AND b . active = 1 AND b . show_brand = 1
AND (p . copy_from_id is NULL OR p . copy_from_id = '' ) AND p . category_id = ? AND p . fl_alat = 1
GROUP BY p . brand_id
ORDER BY b . brand_name
SELECT COUNT (p . id ) broj_proizvoda , b . id AS brand_id , b . brand_name , brand_image
FROM proizvodi p , proizvodjaci b
WHERE p . brand_id = b . id
AND p . active = 1 AND p . show_product = 1 AND b . active = 1 AND b . show_brand = 1
AND (p . copy_from_id is NULL OR p . copy_from_id = '' ) AND p . category_id = 792 AND p . fl_alat = 1
GROUP BY p . brand_id
ORDER BY b . brand_name ; Copy
38
0.40 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 :
[
1780704512
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780704512 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
39
1.24 ms
SELECT b . id AS brand_id , b . brand_name , b . num_of_products_aim AS broj_proizvoda
FROM proizvodjaci b
WHERE b . active = 1 AND b . show_brand = 1
ORDER BY broj_proizvoda DESC
LIMIT 25
SELECT b . id AS brand_id , b . brand_name , b . num_of_products_aim AS broj_proizvoda
FROM proizvodjaci b
WHERE b . active = 1 AND b . show_brand = 1
ORDER BY broj_proizvoda DESC
LIMIT 25 ; Copy
40
30.18 ms
SELECT COUNT (p . id ) AS uk_broj_aktivnih
FROM proizvodi p
WHERE p . active = 1 AND p . show_product = 1
SELECT COUNT (p . id ) AS uk_broj_aktivnih
FROM proizvodi p
WHERE p . active = 1 AND p . show_product = 1 ; Copy
41
1.24 ms
SELECT COUNT (* ) AS num_brands
FROM proizvodjaci b
WHERE active = 1 AND show_brand = 1 AND num_of_products_aim > 0
SELECT COUNT (* ) AS num_brands
FROM proizvodjaci b
WHERE active = 1 AND show_brand = 1 AND num_of_products_aim > 0 ; Copy
42
0.33 ms
SELECT * FROM upload_images ORDER BY id
SELECT * FROM upload_images ORDER BY id ; Copy