| 1 |
0.37 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 = 508 and active = 1;
|
| 2 |
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 = 1008 and active = 1;
|
| 3 |
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: [
1780712480
"cache_tree_aim_1008"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1008');
|
| 4 |
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 = 1002 and active = 1;
|
| 5 |
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: [
1780712480
"cache_tree_aim_1002"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1002');
|
| 6 |
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 = 170 and active = 1;
|
| 7 |
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: [
1780712480
"cache_tree_aim_170"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_170');
|
| 8 |
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;
|
| 9 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 10 |
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;
|
| 11 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 12 |
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 = 170 and active = 1;
|
| 13 |
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: [
1780712480
"cache_tree_aim_170"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_170');
|
| 14 |
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;
|
| 15 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 16 |
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;
|
| 17 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 18 |
0.10 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 = 35933
ORDER BY file_type;
|
| 19 |
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 = 35933 AND p.share_link != '' AND p.active = 1;
|
| 20 |
0.08 ms |
SELECT *
FROM proizvodi_rejting_star
WHERE product_id = ?
SELECT *
FROM proizvodi_rejting_star
WHERE product_id = 35933;
|
| 21 |
0.10 ms |
SELECT *
FROM proizvodi_komentari
WHERE id_proizvoda = ? and active = 1
ORDER BY vreme DESC
SELECT *
FROM proizvodi_komentari
WHERE id_proizvoda = 35933 and active = 1
ORDER BY vreme DESC;
|
| 22 |
0.36 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');
|
| 23 |
0.30 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 = 35933 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;
|
| 24 |
0.40 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 = 1008 and active = 1;
|
| 25 |
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: [
1780712480
"cache_tree_aim_1008"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1008');
|
| 26 |
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 = 1002 and active = 1;
|
| 27 |
0.12 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: [
1780712480
"cache_tree_aim_1002"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1002');
|
| 28 |
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 = 170 and active = 1;
|
| 29 |
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: [
1780712480
"cache_tree_aim_170"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_170');
|
| 30 |
0.36 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;
|
| 31 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 32 |
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 = 1 and active = 1;
|
| 33 |
0.12 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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 34 |
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 = 170 and active = 1;
|
| 35 |
0.12 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: [
1780712480
"cache_tree_aim_170"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_170');
|
| 36 |
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 = 1 and active = 1;
|
| 37 |
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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 38 |
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;
|
| 39 |
0.12 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: [
1780712480
"cache_tree_aim_1"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_1');
|
| 40 |
4.09 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 = 1008 AND p.fl_alat = 1
GROUP BY p.brand_id
ORDER BY b.brand_name;
|
| 41 |
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: [
1780712480
"cache_tree_aim_21"
]
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1780712480 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('cache_tree_aim_21');
|
| 42 |
1.04 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;
|
| 43 |
20.88 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;
|
| 44 |
0.76 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;
|
| 45 |
0.12 ms |
SELECT * FROM upload_images ORDER BY id
SELECT * FROM upload_images ORDER BY id;
|