+36 30/829-0737
rendeles@brillbird.hu
Kapcsolat
A kosár üres.
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?906μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 18:39:56 |
| 3 | 2025-04-09 18:39:56 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?514μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 18:39:56 |
| 3 | 2025-04-09 18:39:56 |
SELECT products.id, products.name, products.slug, products.ean_code, products.price, products.product_category_id, products.discount_price, products.discount_type, products.stock, products.sales_start, products.sales_end, products.images, products.new, products.featured, products.outlet, products.bestseller, ps.unit, category.slug as category_slug, category.id as category_id, category.name as category_name, CASE
WHEN sales_start < CURRENT_TIMESTAMP() AND sales_end > CURRENT_TIMESTAMP()
then case when discount_type = 'value' then price - discount_price ELSE price * ((100 - discount_price) / 100) END
ELSE price
END AS current_price, IFNULL(
JSON_VALUE(images, "$.main"),
JSON_VALUE(images, "$.images[0]")
) as lead_image FROM products LEFT JOIN product_product_size pps ON `pps`.`product_id` = `products`.`id` LEFT JOIN product_sizes ps ON `pps`.`product_size_id` = `ps`.`id` LEFT JOIN product_categories category ON `products`.`product_category_id` = `category`.`id` WHERE `products`.`deleted` = ? and `products`.`active` = ? and 0 = 1659μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?299μs| Params | |
|---|---|
| 0 | 2025-04-09 18:39:56 |
| 1 | 2025-04-09 18:39:56 |
| 2 | 1 |
| 3 | 0 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?557μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:56 |
| 3 | 2025-04-09 20:39:56 |
SELECT title, data, description FROM custom_product_pages WHERE `custom_product_pages`.`deleted` = ? and `custom_product_pages`.`active` = ? and `slug` = ? and (`custom_product_pages`.`deleted` = ? and `custom_product_pages`.`active` = ? and `active_from` is null or `active_from` <= ?) and (`custom_product_pages`.`deleted` = ? and `custom_product_pages`.`active` = ? and `active_to` is null or `active_to` >= ?) LIMIT 1944μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | pedikur |
| 3 | false |
| 4 | true |
| 5 | 2025-04-09 20:39:56 |
| 6 | false |
| 7 | true |
| 8 | 2025-04-09 20:39:56 |
SELECT articles.slug, articles.title, articles.content, seo.title as seo_title, seo.description as seo_description, seo.keywords as seo_keywords FROM articles LEFT JOIN seo ON `seo`.`seoable_id` = `articles`.`id` and `seoable_type` = ? WHERE ``.`deleted` = ? and `active` = ? and `slug` = ? LIMIT 1898μs| Params | |
|---|---|
| 0 | articles |
| 1 | false |
| 2 | true |
| 3 | pedikur |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?481μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:56 |
| 3 | 2025-04-09 20:39:56 |
SELECT product_categories.id, product_categories.name, product_categories.parent_id, product_categories.priority, product_categories.slug, product_categories.lead, product_categories.description, product_categories.image, seo.title as seo_title, seo.description as seo_description, seo.keywords as seo_keywords FROM product_categories LEFT JOIN seo ON `seo`.`seoable_id` = `product_categories`.`id` and `seoable_type` = ? WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `product_categories`.`slug` = ? LIMIT 11.44ms| Params | |
|---|---|
| 0 | product_categories |
| 1 | false |
| 2 | true |
| 3 | pedikur |
SELECT product_categories.id, product_categories.name, product_categories.parent_id, product_categories.priority, product_categories.slug, product_categories.lead, product_categories.description, product_categories.image FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `parent_id` = ? ORDER BY `priority` ASC980μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 88 |
(SELECT id, name, slug, priority FROM product_categories WHERE priority > 880 and product_categories.parent_id = 83 and active = 1 and deleted = 0 ORDER BY priority asc LIMIT 1)
UNION
(SELECT id, name, slug, priority FROM product_categories WHERE priority < 880 and product_categories.parent_id = 83 and active = 1 and deleted = 0 ORDER BY priority DESC LIMIT 1)910μsSELECT distinct products.id, products.name, products.sales_start, products.sales_end, products.price, products.discount_price, products.discount_type, products.new, products.slug, products.stock, products.ean_code, CASE
WHEN sales_start < CURRENT_TIMESTAMP() AND sales_end > CURRENT_TIMESTAMP()
then case when discount_type = 'value' then price - discount_price ELSE price * ((100 - discount_price) / 100) END
ELSE price
END AS current_price, product_sizes.id as size_id, product_sizes.unit as size_unit, product_sizes.value as size_value, product_categories.slug as category_slug, product_categories.id as category_id, product_categories.name as category_name, IFNULL(
JSON_VALUE(images, "$.main"),
JSON_VALUE(images, "$.images[0]")
) as lead_image FROM products LEFT JOIN product_product_category ON `products`.`id` = `product_product_category`.`product_id` LEFT JOIN product_product_size ON `products`.`id` = `product_product_size`.`product_id` LEFT JOIN product_sizes ON `product_sizes`.`id` = `product_product_size`.`product_size_id` LEFT JOIN product_categories ON `products`.`product_category_id` = `product_categories`.`id` LEFT JOIN product_priorities ON `products`.`id` = `product_priorities`.`product_id` WHERE `products`.`deleted` = ? and `products`.`active` = ? and `products`.`product_category_id` = ? or `product_product_category`.`product_category_id` = ? and `product_categories`.`active` = ? and `product_categories`.`deleted` = ? and `products`.`active` = ? and `products`.`deleted` = ? ORDER BY `product_priorities`.`default_priority` ASC24.9ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 88 |
| 3 | 88 |
| 4 | 1 |
| 5 | 0 |
| 6 | true |
| 7 | false |
SELECT badges.*, product_badge.product_id FROM product_badge LEFT JOIN badges ON `product_badge`.`badge_id` = `badges`.`id` WHERE `product_id` IN (?) ORDER BY `badges`.`priority` ASC526μs| Params | |
|---|---|
| 0 | 12329 |
SELECT badges.* FROM badges WHERE (`price_min` > ? and `price_min` is not null) or (`price_max` > ? and `price_max` is not null) ORDER BY `badges`.`priority` ASC283μs| Params | |
|---|---|
| 0 | 0 |
| 1 | 0 |
SELECT id, name, link as url, image, mobile_image, new_window FROM banners WHERE ``.`deleted` = ? and `active` = ? and (``.`deleted` = ? and `active` = ? and `active_from` is null or `active_from` <= ?) and (``.`deleted` = ? and `active` = ? and `active_to` is null or `active_to` >= ?) and (``.`deleted` = ? and `active` = ? and `type` = ? or `type` = ?) and (``.`deleted` = ? and `active` = ? and `urls` is null or (``.`deleted` = ? and `active` = ? and `url_type` = ? and `urls` not like ?) or (``.`deleted` = ? and `active` = ? and `url_type` = ? and `urls` like ?)) LIMIT 1563μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | false |
| 3 | true |
| 4 | 2025-04-09 20:39:57 |
| 5 | false |
| 6 | true |
| 7 | 2025-04-09 20:39:57 |
| 8 | false |
| 9 | true |
| 10 | list |
| 11 | all |
| 12 | false |
| 13 | true |
| 14 | false |
| 15 | true |
| 16 | not allowed |
| 17 | %pedikur% |
| 18 | false |
| 19 | true |
| 20 | allowed |
| 21 | %pedikur% |
SELECT * FROM product_category_filter WHERE `product_category_id` = ?250μs| Params | |
|---|---|
| 0 | 88 |
SELECT * FROM seo WHERE `seoable_type` = ? and `seoable_id` = ? LIMIT 1422μs| Params | |
|---|---|
| 0 | pages |
| 1 | /pedikur |
SELECT id, name, url, is_megamenu, parent_id, location, sectionables.sections FROM menu_items LEFT JOIN sectionables ON `menu_items`.`id` = `sectionables`.`sectionable_id` and `sectionables`.`sectionable_type` = ? WHERE `menu_items`.`deleted` = ? and `menu_items`.`active` = ? and (`menu_items`.`deleted` = ? and `menu_items`.`active` = ? and `sectionables`.`sectionable_type` = ? or `sectionables`.`sectionable_type` is null) ORDER BY `priority` ASC992μs| Params | |
|---|---|
| 0 | menu_items |
| 1 | false |
| 2 | true |
| 3 | false |
| 4 | true |
| 5 | menu_items |
SELECT product_categories.id, product_categories.name, product_categories.parent_id, product_categories.priority, product_categories.slug, product_categories.lead, product_categories.description, product_categories.image FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? ORDER BY `priority` ASC7.54ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?9.04ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:57 |
| 3 | 2025-04-09 20:39:57 |
SELECT products.id, products.name, products.slug, products.ean_code, products.price, products.product_category_id, products.discount_price, products.discount_type, products.stock, products.sales_start, products.sales_end, products.images, products.new, products.featured, products.outlet, products.bestseller, ps.unit, category.slug as category_slug, category.id as category_id, category.name as category_name, CASE
WHEN sales_start < CURRENT_TIMESTAMP() AND sales_end > CURRENT_TIMESTAMP()
then case when discount_type = 'value' then price - discount_price ELSE price * ((100 - discount_price) / 100) END
ELSE price
END AS current_price, IFNULL(
JSON_VALUE(images, "$.main"),
JSON_VALUE(images, "$.images[0]")
) as lead_image FROM products LEFT JOIN product_product_size pps ON `pps`.`product_id` = `products`.`id` LEFT JOIN product_sizes ps ON `pps`.`product_size_id` = `ps`.`id` LEFT JOIN product_categories category ON `products`.`product_category_id` = `category`.`id` WHERE `products`.`deleted` = ? and `products`.`active` = ? and 0 = 1960μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?500μs| Params | |
|---|---|
| 0 | 2025-04-09 20:39:57 |
| 1 | 2025-04-09 20:39:57 |
| 2 | 1 |
| 3 | 0 |
SELECT product_categories.id, product_categories.name, product_categories.parent_id, product_categories.priority, product_categories.slug, product_categories.lead, product_categories.description, product_categories.image FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? ORDER BY `priority` ASC2.73ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT id, name, slug, parent_id FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `id` = ? LIMIT 11.83ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 88 |
SELECT id, name, slug, parent_id FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `id` = ? LIMIT 1290μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 83 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?544μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:57 |
| 3 | 2025-04-09 20:39:57 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?472μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:57 |
| 3 | 2025-04-09 20:39:57 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?796μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:57 |
| 3 | 2025-04-09 20:39:57 |
SELECT products.id, products.name, products.slug, products.ean_code, products.price, products.product_category_id, products.discount_price, products.discount_type, products.stock, products.sales_start, products.sales_end, products.images, products.new, products.featured, products.outlet, products.bestseller, ps.unit, category.slug as category_slug, category.id as category_id, category.name as category_name, CASE
WHEN sales_start < CURRENT_TIMESTAMP() AND sales_end > CURRENT_TIMESTAMP()
then case when discount_type = 'value' then price - discount_price ELSE price * ((100 - discount_price) / 100) END
ELSE price
END AS current_price, IFNULL(
JSON_VALUE(images, "$.main"),
JSON_VALUE(images, "$.images[0]")
) as lead_image FROM products LEFT JOIN product_product_size pps ON `pps`.`product_id` = `products`.`id` LEFT JOIN product_sizes ps ON `pps`.`product_size_id` = `ps`.`id` LEFT JOIN product_categories category ON `products`.`product_category_id` = `category`.`id` WHERE `products`.`deleted` = ? and `products`.`active` = ? and 0 = 1533μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?298μs| Params | |
|---|---|
| 0 | 2025-04-09 20:39:57 |
| 1 | 2025-04-09 20:39:57 |
| 2 | 1 |
| 3 | 0 |
select * from delivery_discount where active = ? and start_date is null and end_date is null578μs| Params | |
|---|---|
| 0 | 1 |
SELECT price FROM delivery_discount WHERE `active` = ? and `start_date` <= ? and `end_date` >= ? LIMIT 1522μs| Params | |
|---|---|
| 0 | 1 |
| 1 | 2025-04-09 20:39:57 |
| 2 | 2025-04-09 20:39:57 |
SELECT product_categories.id, product_categories.name, product_categories.parent_id, product_categories.priority, product_categories.slug, product_categories.lead, product_categories.description, product_categories.image FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? ORDER BY `priority` ASC1.24ms| Params | |
|---|---|
| 0 | false |
| 1 | true |
SELECT id, name, link as url, image, mobile_image, new_window FROM popups WHERE `popups`.`deleted` = ? and `active` = ? and (`active_from` is null or `active_from` <= ?) and (`active_to` is null or `active_to` >= ?) and `type` = ?786μs| Params | |
|---|---|
| 0 | false |
| 1 | true |
| 2 | 2025-04-09 20:39:57 |
| 3 | 2025-04-09 20:39:57 |
| 4 | all |