A kosár üres.
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?
1.24msParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 20:20:57 |
3 | 2025-04-08 20:20:57 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?
584μsParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 20:20:57 |
3 | 2025-04-08 20:20: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 = 1
510μsParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?
295μsParams | |
---|---|
0 | 2025-04-08 20:20:57 |
1 | 2025-04-08 20:20:57 |
2 | 1 |
3 | 0 |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?
665μsParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 22:20:57 |
3 | 2025-04-08 22:20: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 = 1
429μsParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM seo WHERE `seoable_type` = ? and `seoable_id` = ? LIMIT 1
499μsParams | |
---|---|
0 | pages |
1 | /kedvenceim |
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` ASC
956μsParams | |
---|---|
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` ASC
1.17msParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?
632μsParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 22:20:57 |
3 | 2025-04-08 22:20: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 = 1
518μsParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?
702μsParams | |
---|---|
0 | 2025-04-08 22:20:57 |
1 | 2025-04-08 22:20: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` ASC
1.19msParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?
697μsParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 22:20:57 |
3 | 2025-04-08 22:20: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 = 1
430μsParams | |
---|---|
0 | false |
1 | true |
SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?
377μsParams | |
---|---|
0 | 2025-04-08 22:20:57 |
1 | 2025-04-08 22:20:57 |
2 | 1 |
3 | 0 |
select * from delivery_discount where active = ? and start_date is null and end_date is null
724μsParams | |
---|---|
0 | 1 |
SELECT price FROM delivery_discount WHERE `active` = ? and `start_date` <= ? and `end_date` >= ? LIMIT 1
257μsParams | |
---|---|
0 | 1 |
1 | 2025-04-08 22:20:57 |
2 | 2025-04-08 22:20: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` ASC
711μsParams | |
---|---|
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` = ?
475μsParams | |
---|---|
0 | false |
1 | true |
2 | 2025-04-08 22:20:57 |
3 | 2025-04-08 22:20:57 |
4 | all |