1
6.52 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 :
[
"akumulatorski-alat-za-vezivanje-armature "
]
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 = 'akumulatorski-alat-za-vezivanje-armature' and active = 1 ; Copy
2
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 :
[
1780700144
"cache_tree_aim_481 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_481' ); Copy
3
8.99 ms
DELETE FROM cache_items WHERE item_lifetime + item_time < = ? AND item_id IN (? )
Parameters :
[
1780700144
"cache_tree_aim_481 "
]
DELETE FROM cache_items WHERE item_lifetime + item_time < = 1780700144 AND item_id IN ('cache_tree_aim_481' ); Copy
4
0.77 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 = 481 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 = 481 and c1 . active = 1 and c2 . show_category = 1 AND c2 . fl_alat = 1 )
ORDER BY category_name ; Copy
5
8.53 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 => 1780700144
0 => "cache_tree_aim_481 "
1 => "a:2:{s:13:"subCategories";a:0:{}s:8:"products";a:3:{i:0;a:6:{s:2:"id";s:5:"72264";s:10:"product_id";i:72264;s:4:"name";s:56:"Akumulatorski alat za vezivanje armature DTR180ZK Makita";s:12:"product_name";s:56:"Akumulatorski alat za vezivanje armature DTR180ZK Makita";s:3:"url";s:56:"akumulatorski-alat-za-vezivanje-armature-dtr180zk-makita";s:4:"path";s:13:"/1/21/22/481/";}i:1;a:6:{s:2:"id";s:6:"116640";s:10:"product_id";i:116640;s:4:"name";s:66:"Makita TR001GZ akumulatorska mašina za vezivanje armature 40V XGT";s:12:"product_name";s:66:"Makita TR001GZ akumulatorska mašina za vezivanje armature 40V XGT";s:3:"url";s:65:"makita-tr001gz-akumulatorska-masina-za-vezivanje-armature-40v-xgt";s:4:"path";s:13:"/1/21/22/481/";}i:2;a:6:{s:2:"id";s:6:"110959";s:10:"product_id";i:110959;s:4:"name";s:65:"RB443T – Alat za vezivanje armature sa žicom debljine 19Ga MAX";s:12:"product_name";s:65:"RB443T – Alat za vezivanje armature sa žicom debljine 19Ga MAX";s:3:"url";s:60:"rb443t-alat-za-vezivanje-armature-sa-zicom-debljine-19ga-max";s:4:"path";s:13:"/1/21/22/481/";}}} "
]
INSERT INTO cache_items (item_id , item_data , item_lifetime , item_time ) VALUES (3600 , 1780700144 , 'cache_tree_aim_481' , 'a:2:{s:13:\"subCategories\";a:0:{}s:8:\"products\";a:3:{i:0;a:6:{s:2:\"id\";s:5:\"72264\";s:10:\"product_id\";i:72264;s:4:\"name\";s:56:\"Akumulatorski alat za vezivanje armature DTR180ZK Makita\";s:12:\"product_name\";s:56:\"Akumulatorski alat za vezivanje armature DTR180ZK Makita\";s:3:\"url\";s:56:\"akumulatorski-alat-za-vezivanje-armature-dtr180zk-makita\";s:4:\"path\";s:13:\"/1/21/22/481/\";}i:1;a:6:{s:2:\"id\";s:6:\"116640\";s:10:\"product_id\";i:116640;s:4:\"name\";s:66:\"Makita TR001GZ akumulatorska mašina za vezivanje armature 40V XGT\";s:12:\"product_name\";s:66:\"Makita TR001GZ akumulatorska mašina za vezivanje armature 40V XGT\";s:3:\"url\";s:65:\"makita-tr001gz-akumulatorska-masina-za-vezivanje-armature-40v-xgt\";s:4:\"path\";s:13:\"/1/21/22/481/\";}i:2;a:6:{s:2:\"id\";s:6:\"110959\";s:10:\"product_id\";i:110959;s:4:\"name\";s:65:\"RB443T – Alat za vezivanje armature sa žicom debljine 19Ga MAX\";s:12:\"product_name\";s:65:\"RB443T – Alat za vezivanje armature sa žicom debljine 19Ga MAX\";s:3:\"url\";s:60:\"rb443t-alat-za-vezivanje-armature-sa-zicom-debljine-19ga-max\";s:4:\"path\";s:13:\"/1/21/22/481/\";}}}' ) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data ), item_lifetime = VALUES (item_lifetime ), item_time = VALUES (item_time ); Copy
6
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 = 22 and active = 1 ; Copy
7
0.59 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 :
[
1780700144
"cache_tree_aim_22 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_22' ); Copy
8
0.33 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.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 :
[
1780700144
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
10
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 = 1 and active = 1 ; Copy
11
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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
12
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 = 1 and active = 1 ; Copy
13
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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
14
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 = 21 and active = 1 ; Copy
15
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 :
[
1780700144
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
16
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 = 1 and active = 1 ; Copy
17
0.16 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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
18
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
19
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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
20
0.24 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 = 481 and active = 1 ; Copy
22
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 :
[
1780700144
"cache_tree_aim_481 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_481' ); Copy
23
0.18 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 = 22 and active = 1 ; Copy
24
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 :
[
1780700144
"cache_tree_aim_22 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_22' ); Copy
25
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 = 21 and active = 1 ; Copy
26
0.16 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 :
[
1780700144
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
27
0.15 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.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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
29
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 = 1 and active = 1 ; Copy
30
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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
31
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 = 21 and active = 1 ; Copy
32
0.16 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 :
[
1780700144
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
33
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 = 1 and active = 1 ; Copy
34
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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
35
0.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 ,
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.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 :
[
1780700144
"cache_tree_aim_1 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1' ); Copy
37
0.48 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 = 481 AND p . fl_alat = 1
GROUP BY p . brand_id
ORDER BY b . brand_name ; Copy
38
0.28 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 :
[
1780700144
"cache_tree_aim_21 "
]
SELECT item_id , CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780700144 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21' ); Copy
39
0.80 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
20.38 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.72 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.19 ms
SELECT * FROM upload_images ORDER BY id
SELECT * FROM upload_images ORDER BY id ; Copy