-- Bestel uw vuurwerk voordelig en snel op www.vuurwerktoppers.nl!! -- WTF! Kortingen tot 85% -- Spectaculaire acties met hoge kortingen!!

Pyro Giant

art. 599
269,99
-15%
229,95

Brutal Leader

art. 595
129,99
-8%
119,95

Quattro Pack

art. 3480
79,99

Black celebration cracker 100.000

art. 2067
69,99
-43%
39,95

Gold rush

art. 6220
59,99

King of Thunder

art. 140
49,99
-50%
24,95

WTF BOX

art. 3470
39,99

Willow fan

art. 3490
32,50

Midnight Blossom

art. 725
29,95
-3%
28,95

Magnolia spectacle

art. 2305
23,50

Stargate

art. 6212
23,49

Metersierpakket

art. 2980
22,99
-24%
17,50

Mysterious

art. 6240
19,99

Epic Shock XL

art. 2324
17,99
-31%
12,50

Space Power

art. 710
18,75

Thunder rockets 6 stuks

art. 2330
8,99
-47%
4,75

Black Cracker

art. 2014
3,99
-50%
1,99

Sniper Shocks

art. 138
2,99
-52%
1,45

Pijlstandaard

art. 935
3,99
-56%
1,75

Jumping Jack Azaro 144

art. 2252
1,99
-57%
0,85

Epic Shocks

art. 2323
1,69
-41%
1,00

Grondbloemen

art. 2317
1,59
-38%
0,99
  BENCHMARKS  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Products / Powerprices )  0.0410
  :  caff   QUERIES: 45  ()
0.0011   SELECT table_name FROM information_schema.tables WHERE table_schema 'public' 
0.0001   SET bytea_output=escape 
0.0005   SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('stunthal') 
0.0003  
            SELECT id
                 
dealer_id
                 
street
                 
house_number
                 
zip_code
                 
country
                 
city
                 
latitude
                 
longitude
                 
deleted
                 
webshop_active
                 
webshop_slug
                 
webshop_marquee_text
                 
webshop_information
                 
webshop_store_hours
                 
webshop_ordering_allowed
                 
webshop_twitter
                 
webshop_facebook
                 
max_kilo_per_timezone
                 
max_orders_per_timezone
                 
email_address
                 
webshop_order_cc_email_address
                 
logo_path
                 
webshop_online_folder_path
                 
name
                 
webshop_resell_enabled
                 
webshop_resell_discount_percentage
                 
seo_text
                 
api_key
              FROM delivery_addresses
             WHERE id 
'431' AND deleted 'f'
         
0.0002  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'431'
         
0.0003  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'431'
            
ORDER BY start_time ASC
             
0.0003  
              SELECT id
                   
name
                   
internal_name
                   
active
                   
remark
                   
debtor_number
                   
prepay
                   
automatic_reservations
                   
invoice_email_address
                   
invoice_address_street
                   
invoice_address_house_number
                   
invoice_address_zip_code
                   
invoice_address_country
                   
invoice_address_city
                   
price_list_id
                   
free_products
                   
free_products_cash_register
                   
product_set_id
                   
pin_enabled
                   
wants_newsletter
                   
has_price_control
                   
allow_minus_sales
                   
is_platinum
                FROM dealers
               WHERE deleted 
false
                 
AND id '390'
            
ORDER BY name ASC
         
0.0003  
            SELECT id
                 
dealer_id
                 
street
                 
house_number
                 
zip_code
                 
country
                 
city
                 
latitude
                 
longitude
                 
deleted
                 
webshop_active
                 
webshop_slug
                 
webshop_marquee_text
                 
webshop_information
                 
webshop_store_hours
                 
webshop_ordering_allowed
                 
webshop_twitter
                 
webshop_facebook
                 
max_kilo_per_timezone
                 
max_orders_per_timezone
                 
email_address
                 
webshop_order_cc_email_address
                 
logo_path
                 
webshop_online_folder_path
                 
name
                 
webshop_resell_enabled
                 
webshop_resell_discount_percentage
                 
driving_time
                 
api_key
              FROM delivery_addresses
             WHERE 
'390' IS NULL OR dealer_id '390' AND deleted 'f'
          
ORDER BY city ASC
         
0.0002  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'431'
         
0.0002  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'431'
            
ORDER BY start_time ASC
             
0.0002  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '390'
         
0.0003  
            SELECT id
                 
name
                 
active
                 
invoice_email_address
                 
remark
                 
debtor_number
                 
prepay
                 
automatic_reservations
                 
invoice_address_street
                 
invoice_address_house_number
                 
invoice_address_zip_code
                 
invoice_address_country
                 
invoice_address_city
                 
deleted
                 
price_list_id
                 
free_products
                 
product_set_id
                 
wants_newsletter
                 
pin_enabled
                 
has_price_control
                 
free_products_cash_register
              FROM dealers
             WHERE id IN 
('390')
         
0.0003  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '390'
         
0.0004  
            SELECT id FROM product_sets WHERE id 
'8'
         
0.0005  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'8'
                 
0.0003  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'8'
             
0.0007  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id NULL
         
0.0008  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '1178'
         
0.0006  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '1178'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1178'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0007  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '144'
         
0.0005  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '144'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'144'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'14'
         
0.0007  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '476'
         
0.0006  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '476'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'476'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'18'
         
0.0007  
               SELECT p
.id
                    
p.namep.description
                    
p.brand_idb.name AS brand_name
                    
p.active
                    
p.gross_weight_per_boxp.weight_per_article
                    
p.barcode_boxp.barcode_productp.skup.article_number
                    
p.ce_numberp.ce_categoryp.nem_per_box
                    
p.hazard_code_class_numberp.hazard_code_compatibility_group
                    
p.sales_price_per_articlep.sales_price_per_article_for_discountp.power_price
                    
p.burn_timep.effect_height
                    
p.articles_per_boxp.packed_by
                    
p.warehouse_locationp.warehouse_sublocation
                    
p.shots_per_cakep.is_fan
                    
p.primary_image_id
                    
p.slug
                    
p.is_safety_product
                    
p.expose_in_api
                    
p.min_main_warehouse_stock
                    
p.cbm
                    
p.is_rocket
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id '1180'
         
0.0006  
                SELECT c
.namec.idc.slug
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id '1180'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1180'
         
0.0003  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0011  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'390'

                 
UNION

                SELECT psp
.product_id AS id
                  FROM product_set_products 
AS psp
                 WHERE psp
.product_set_id ( SELECT d.product_set_id
                                                FROM dealers 
AS d
                                               WHERE d
.id '390'
                                            
)
             
0.0014  
               SELECT p
.*, b.name AS brand_name
                 FROM products 
AS p

            LEFT JOIN product_brands 
AS b
                   ON b
.id p.brand_id            

                WHERE p
.id IN (1465521075162169330156106754719761364147511674706386151493291085601420153328147691324357331107036616511646166361084325673571107116310585963271671585941551954591076207702699369118032659510731178157413107259710985736141591541074185148612)
                
ORDER BY p.name
         
0.0016  
                SELECT c
.namec.idc.slugcz.product_id
                  FROM product_categories 
AS c
                  JOIN product_categorizations 
AS cz
                    ON cz
.category_id c.id
                 WHERE cz
.product_id IN (1465521075162169330156106754719761364147511674706386151493291085601420153328147691324357331107036616511646166361084325673571107116310585963271671585941551954591076207702699369118032659510731178157413107259710985736141591541074185148612)
             
0.0004  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(291532142021182617313427)
         
0.0008  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(1465521075162169330156106754719761364147511674706386151493291085601420153328147691324357331107036616511646166361084325673571107116310585963271671585941551954591076207702699369118032659510731178157413107259710985736141591541074185148612)
         
0.0010  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '390'
                                              
AND pp.product_id p.id
                                      
)
                       , 
p.sales_price_per_article
                       
)
            
                     ELSE 
p.sales_price_per_article
                     END
                   
) AS price
            FROM products 
AS p
            WHERE p
.id IN (1465521075162169330156106754719761364147511674706386151493291085601420153328147691324357331107036616511646166361084325673571107116310585963271671585941551954591076207702699369118032659510731178157413107259710985736141591541074185148612)
            
ORDER BY p.id        
         
0.0007  
                SELECT 
*
                  
FROM dealer_product_prices
                 WHERE product_id
                        IN 
(3661561581571541591551621631651164614148149147413117811674591067325612107342010853244701851671074673573108435710704757021956381075329691331207369105810713286165526136011975945975955961072326327571636109854716915364161514610763306991180)
                   AND 
dealer_id '390'
             
0.0017  
            SELECT
              products
.id,
              
products.name,
              
products.article_number,
              
alternative_products.original_product_article
              FROM alternative_products
              JOIN products on products
.article_number alternative_products.article_number
                WHERE alternative_products
.original_product_article IN (9252065206720662014207120252479248026182027595205420562050206034195982323232435105922362220635853505622023172212236522521403500354822312305755298072523673535624035502670935922224935305993480593540298550552051051523603520352513871059462122220233075059720222370354634903470) 
                AND 
alternative_products.article_number IN (9252065206720662014207120252479248026182027595205420562050206034195982323232435105922362220635853505622023172212236522521403500354822312305755298072523673535624035502670935922224935305993480593540298550552051051523603520352513871059462122220233075059720222370354634903470)
              
0.0003  
                  SELECT id
parent_idnameimage_pathactiveslug
                    FROM product_categories
                   WHERE active 
't'
             
0.0003  
                    SELECT condition FROM admin_settings
                    WHERE name 
'overview_check_stocks'
         
0.0004  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'431' 
               
AND product_id IN (15815461445910674701856735734751956386913696165525716365471536991180)
         
0.0003  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'390' 
         
    
$_GET['dealer']   stunthal
  POST DATA  
Er is geen POST data
    
2,974,688 bytes
    
webshops
    
products/powerprices
    ()
HTTP_ACCEPT  text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_USER_AGENT  CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_CONNECTION  Keep-Alive
SERVER_PORT  443
SERVER_NAME  infovuurwerk.nl
REMOTE_ADDR  34.207.82.217
SERVER_SOFTWARE  nginx/1.15.3
HTTP_ACCEPT_LANGUAGE  en-US,en;q=0.5
SCRIPT_NAME  /index.php
REQUEST_METHOD  GET
HTTP_HOST  
REMOTE_HOST  
CONTENT_TYPE  
SERVER_PROTOCOL  HTTP/1.1
QUERY_STRING  dealer=stunthal
HTTP_ACCEPT_ENCODING  gzip
HTTP_X_FORWARDED_FOR  
    ()
base_url  https://infovuurwerk.nl/
index_page  
uri_protocol  AUTO
url_suffix  
language  dutch
charset  UTF-8
enable_hooks  
subclass_prefix  CAFF_
permitted_uri_chars  a-z 0-9~%.,|:_\-\ä\ü\ö\ë\ï\á\ú\ó\é\í
allow_get_array  1
enable_query_strings  
controller_trigger  c
function_trigger  m
directory_trigger  d
log_threshold  0
log_path  
log_date_format  Y-m-d H:i:s
cache_path  
encryption_key  some random string
jwt_secret_key  MxKkIS87PgIxB7UAuT3oBFthO8PG3AiPkD6FSlAETQ
sess_cookie_name  ci_session
sess_expiration  86400
sess_expire_on_close  
sess_encrypt_cookie  
sess_use_database  
sess_table_name  ci_sessions
sess_match_ip  
sess_match_useragent  1
sess_time_to_update  300
cookie_prefix  
cookie_domain  
cookie_path  /
cookie_secure  
global_xss_filtering  
csrf_protection  
csrf_token_name  csrf_test_name
csrf_cookie_name  csrf_cookie_name
csrf_expire  7200
compress_output  
time_reference  local
rewrite_short_tags  
proxy_ips