1
2.95 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 :
[
"benzinski-peraci-pod-pritiskom "
]
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 = 'benzinski-peraci-pod-pritiskom' and active = 1 ; Copy
2
28.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 :
[
1780699969
"cache_tree_aim_133 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699969 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_133' ); Copy
3
45.82 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780699969
"cache_tree_aim_133 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780699969 AND item_id IN ('cache_tree_aim_133' ); Copy
4
31.63 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 = 133 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 = 133 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ; Copy
5
93.93 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 => 1780699970
0 => "cache_tree_aim_133 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:2:{i:0;a:6:{s:2:"id";s:6:"109682";s:10:"product_id";i:109682;s:4:"name";s:58:"Scheppach motorni perač visokim pritiskom HCP5000 240 bar";s:12:"product_name";s:58:"Scheppach motorni perač visokim pritiskom HCP5000 240 bar";s:3:"url";s:57:"scheppach-motorni-perac-visokim-pritiskom-hcp5000-240-bar";s:4:"path";s:14:"/1/21/126/133/";}i:1;a:6:{s:2:"id";s:6:"119989";s:10:"product_id";i:119989;s:4:"name";s:40:"Perač pod visokim pritiskom W-HR 3000 i";s:12:"product_name";s:40:"Perač pod visokim pritiskom W-HR 3000 i";s:3:"url";s:39:"perac-pod-visokim-pritiskom-w-hr-3000-i";s:4:"path";s:14:"/1/21/126/133/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780699970 , 'cache_tree_aim_133' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:2:{i:0;a:6:{s:2:\"id\";s:6:\"109682\";s:10:\"product_id\";i:109682;s:4:\"name\";s:58:\"Scheppach motorni perač visokim pritiskom HCP5000 240 bar\";s:12:\"product_name\";s:58:\"Scheppach motorni perač visokim pritiskom HCP5000 240 bar\";s:3:\"url\";s:57:\"scheppach-motorni-perac-visokim-pritiskom-hcp5000-240-bar\";s:4:\"path\";s:14:\"/1/21/126/133/\";}i:1;a:6:{s:2:\"id\";s:6:\"119989\";s:10:\"product_id\";i:119989;s:4:\"name\";s:40:\"Perač pod visokim pritiskom W-HR 3000 i\";s:12:\"product_name\";s:40:\"Perač pod visokim pritiskom W-HR 3000 i\";s:3:\"url\";s:39:\"perac-pod-visokim-pritiskom-w-hr-3000-i\";s:4:\"path\";s:14:\"/1/21/126/133/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time ); Copy
6
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 = 126 and active = 1 ; Copy
7
44.75 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 :
[
1780699970
"cache_tree_aim_126 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_126' ); Copy
8
0.30 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.26 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 :
[
1780699970
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
10
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
11
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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
12
0.17 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.17 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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
14
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 = 21 and active = 1 ; Copy
15
0.18 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 :
[
1780699970
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
16
0.16 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.13 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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
18
0.17 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.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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
20
0.19 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.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 = 133 and active = 1 ; Copy
22
0.13 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 :
[
1780699970
"cache_tree_aim_133 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_133' ); Copy
23
0.20 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 = 126 and active = 1 ; Copy
24
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 :
[
1780699970
"cache_tree_aim_126 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_126' ); Copy
25
0.16 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
26
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 :
[
1780699970
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
27
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 = 1 and active = 1 ; Copy
28
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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
29
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
30
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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
31
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 = 21 and active = 1 ; Copy
32
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 :
[
1780699970
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
33
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 = 1 and active = 1 ; Copy
34
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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
35
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
36
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 :
[
1780699970
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
37
0.34 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 = 133 AND p . fl_alat = 1
GROUP BY p . brand_id
ORDER BY b . brand_name ; Copy
38
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 :
[
1780699970
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780699970 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
39
0.54 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
16.75 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
0.48 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.07 ms
SELECT * FROM upload_images ORDER BY id
SELECT * FROM upload_images ORDER BY id ; Copy