Kosár

A kosár üres.

Kategóriák

A Weboldalon szereplő képek kizárólag illusztrációk.

favorite_border

Hypnotic gel&lac 8ml 87

Vonalkód: 5999077708672

2 990 Ft

Raktáron, szállítható

Ingyenes szállítás
15.000 Ft felett

A Gel&Lac-ok új generációja gyönyörű, színnel azonos üvegekben! Vendégeitek már az üvegre pillantva eldönthetik, melyik illik hozzájuk - már ha tudnak egyáltalán választani a megbabonázó Hypnotic Gel&Lac színek közül.

Hasonló termékek

Légy naprakész

Értesülj egy pillantás alatt a legújabb körmös hírekről, kedvezményekről és újdonságokról!
8.3.10PHP Version116msRequest Duration4MBMemory Usage
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:4 [ "_sf2_attributes" => & array:2 [ "token" => "ipOeJwZSjs5JZPey9W68xnHzEQzL4AjT" "...
    $_COOKIE
    []
      33 statements were executed, 18 of which were duplicates, 15 unique25.38ms
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?1ms
        Params
        0false
        1true
        22025-01-11 12:10:38
        32025-01-11 12:10:38
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?445μs
        Params
        0false
        1true
        22025-01-11 12:10:38
        32025-01-11 12:10:38
      • 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 = 1544μs
        Params
        0false
        1true
      • SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?345μs
        Params
        02025-01-11 12:10:38
        12025-01-11 12:10:38
        21
        30
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?420μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?277μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • SELECT products.*, 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_categories.slug as category_slug, product_categories.id as category_id, product_categories.name as category_name, JSON_QUERY(images, "$.images") as images, IFNULL( JSON_VALUE(images, "$.main"), JSON_VALUE(images, "$.images[0]") ) as lead_image, seo.title as seo_title, seo.description as seo_description, seo.keywords as seo_keywords, product_sizes.id as size_id, product_sizes.unit as size_unit, product_sizes.value as size_value, youtube_product.youtube_video_id as youtube_video_id FROM products LEFT JOIN product_categories ON `products`.`product_category_id` = `product_categories`.`id` LEFT JOIN seo ON `seo`.`seoable_id` = `products`.`id` and `seoable_type` = ? 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 youtube_product ON `products`.`id` = `youtube_product`.`product_id` LEFT JOIN youtube_videos ON `youtube_videos`.`id` = `youtube_product`.`youtube_video_id` WHERE `products`.`deleted` = ? and `products`.`active` = ? and `product_categories`.`active` = ? and `product_categories`.`deleted` = ? and `products`.`slug` = ? LIMIT 16.05ms
        Params
        0products
        1false
        2true
        31
        40
        5hypnotic-gellac-8ml-87
      • 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` ASC429μs
        Params
        03386
      • 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` ASC431μs
        Params
        00
        10
      • SELECT 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_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 `product_category_id` = ? and `product_categories`.`active` = ? and `product_categories`.`deleted` = ? ORDER BY `product_priorities`.`default_priority` ASC LIMIT 85.08ms
        Params
        0false
        1true
        235
        31
        40
      • 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` ASC401μs
        Params
        02305
        13835
        23973
        33975
        43976
        53979
        63981
        73982
      • 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` ASC280μs
        Params
        00
        10
      • 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 1442μs
        Params
        0false
        1true
        2false
        3true
        42025-01-11 13:10:38
        5false
        6true
        72025-01-11 13:10:38
        8false
        9true
        10show
        11all
        12false
        13true
        14false
        15true
        16not allowed
        17%color-hypnotic-gellakkok/hypnotic-gellac-8ml-87%
        18false
        19true
        20allowed
        21%color-hypnotic-gellakkok/hypnotic-gellac-8ml-87%
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?267μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • SELECT product_ids FROM product_variants WHERE JSON_CONTAINS(product_ids, ?) LIMIT 1310μs
        Params
        03386
      • SELECT products.id, products.slug, 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 FROM products 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` WHERE `products`.`deleted` = ? and `products`.`active` = ? and `product_categories`.`active` = ? and `product_categories`.`deleted` = ? and `products`.`id` IN (?, ?)474μs
        Params
        0false
        1true
        21
        30
        43386
        53384
      • SELECT * FROM seo WHERE `seoable_type` = ? and `seoable_id` = ? LIMIT 1490μs
        Params
        0pages
        1/color-hypnotic-gellakkok/hypnotic-gellac-8ml-87
      • 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` ASC669μs
        Params
        0menu_items
        1false
        2true
        3false
        4true
        5menu_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` ASC743μs
        Params
        0false
        1true
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?436μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • 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 = 1569μs
        Params
        0false
        1true
      • SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?269μs
        Params
        02025-01-11 13:10:38
        12025-01-11 13:10:38
        21
        30
      • 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` ASC731μs
        Params
        0false
        1true
      • SELECT id, name, slug, parent_id FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `id` = ? LIMIT 1490μs
        Params
        0false
        1true
        235
      • SELECT id, name, slug, parent_id FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `id` = ? LIMIT 1267μs
        Params
        0false
        1true
        234
      • SELECT id, name, slug, parent_id FROM product_categories WHERE `product_categories`.`deleted` = ? and `product_categories`.`active` = ? and `id` = ? LIMIT 1219μs
        Params
        0false
        1true
        232
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?570μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • SELECT * FROM product_banners WHERE `product_banners`.`deleted` = ? and `product_banners`.`active` = ? and `active_from` <= ? and `active_to` >= ?493μs
        Params
        0false
        1true
        22025-01-11 13:10:38
        32025-01-11 13:10:38
      • 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 = 1461μs
        Params
        0false
        1true
      • SELECT * FROM special_actions WHERE `start_date` <= ? and `end_date` >= ? and `active` = ? and `deleted` = ?280μs
        Params
        02025-01-11 13:10:38
        12025-01-11 13:10:38
        21
        30
      • select * from delivery_discount where active = ? and start_date is null and end_date is null324μs
        Params
        01
      • SELECT price FROM delivery_discount WHERE `active` = ? and `start_date` <= ? and `end_date` >= ? LIMIT 1237μs
        Params
        01
        12025-01-11 13:10:38
        22025-01-11 13:10:38
      • 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` ASC937μs
        Params
        0false
        1true