17.42 ms
(47.57%)
|
1 |
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;
|
9.72 ms
(26.55%)
|
1 |
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 = 100 AND p.fl_alat = 1
GROUP BY p.brand_id
ORDER BY b.brand_name;
|
4.12 ms
(11.24%)
|
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,
cache_tree, cache_tree_aim, show_eponuda
FROM kategorije
WHERE category_name_seo = ? and active = 1
Parameters: [
"agregati"
]
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 = 'agregati' and active = 1;
|
1.29 ms
(3.52%)
|
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 brand_name_seo = ? 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 brand_name_seo = 'sincro' and active = 1;
|
1.24 ms
(3.40%)
|
10 |
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: [
1780797259
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780797259 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
1.10 ms
(3.00%)
|
8 |
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;
|
0.69 ms
(1.87%)
|
1 |
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;
|
0.64 ms
(1.75%)
|
1 |
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;
|
0.20 ms
(0.54%)
|
1 |
SELECT k.id, k.category_name, k.category_name_seo, k.category_image, k.parent_category_id, k.level,
k.show_category, k.active, k.fl_alat, k.category_name_aim
FROM kategorije k
INNER JOIN brand_to_category bc ON k.id = bc.fk_category_id AND bc.fk_brand_id = ?
WHERE parent_category_id = ? AND active = 1 AND k.fl_alat = 1
SELECT k.id, k.category_name, k.category_name_seo, k.category_image, k.parent_category_id, k.level,
k.show_category, k.active, k.fl_alat, k.category_name_aim
FROM kategorije k
INNER JOIN brand_to_category bc ON k.id = bc.fk_category_id AND bc.fk_brand_id = 496
WHERE parent_category_id = 100 AND active = 1 AND k.fl_alat = 1;
|
0.12 ms
(0.32%)
|
1 |
SELECT page_title, page_meta_description, page_meta_keywords, web_page
FROM website_tags
WHERE website = ? and web_page IN (?, ?)
Parameters: [
2
"brendovi"
"ostale"
]
SELECT page_title, page_meta_description, page_meta_keywords, web_page
FROM website_tags
WHERE website = 2 and web_page IN ('brendovi', 'ostale');
|
0.09 ms
(0.25%)
|
1 |
SELECT * FROM upload_images ORDER BY id
SELECT * FROM upload_images ORDER BY id;
|