* Allerlaagste prijzen van de regio * Knalharde acties * Kortingen tot 85% * 31 december tot 20.00 uur geopend

VUURWERK KOPEN BIJ VENEBOER CAMPING IN DRACHTEN

Veneboer camping Drachten is dé Kampeer, wandelspecialist en vuurwerkspecialist van Noord-Nederland!

Wij beschikken over een groot vuurwerkassortiment! Knalvuurwerk zoals rotjes, thundershocks en spanish crackers, maar ook het mooiste siervuurwerk met cakeboxen tot maar liefst 65 KG kunt u bij ons in de webshop bestellen!

Al het vuurwerk dat wij in onze Vuurwerktoppers webshop verkopen is CE goedgekeurd vuurwerk. Hierdoor bent u dus zeker van kwalitatief goed en veilig vuurwerk.

Vuurwerk kopen Drachten, Beetsterzwaag, Marum, Gorredijk en Surhuisterveen

Wanneer u uw bestelling bij ons in de webshop plaatst ontvangt u gratis de Double Blast! Daarnaast kunt u gebruik maken van onze interessante voorverkoopacties waarmee u nog meer extra gratis vuurwerk krijgt! Uw bestelling kunt u afhalen op 28, 29 en 31 december in onze winkel in Drachten!
Maar let op: de collectie op vuurwerktoppers.nl is alleen online verkrijgbaar. In onze winkel hebben wij een andere collectie dan online. Twijfel dus niet te lang en bestel uw vuurwerk alvast online! Dan bent u verzekerd van het vuurwerk dat u wil en kunt u het afhalen op het moment dat het u het beste uitkomt.

PowerPrijzen

Profi final

art. 2999
269,99
-26%
199,99

Excellent Box

art. 2993
129,99
-23%
99,99

Dream planet

art. 2320
99,99

Night hunter

art. 2315
84,99

Great sphinx

art. 3624
79,99

Quattro Pack

art. 3480
79,99

Black celebration cracker 100.000

art. 2067
69,99
-29%
49,99

Gold rush

art. 6220
59,99

Thunder shock bulk

art. 2329
49,99
-30%
34,99

WTF BOX

art. 3470
39,99

Willow fan

art. 3490
32,50

Record breaker

art. 6230
24,99

Magnolia spectacle

art. 2305
23,50

Stargate

art. 6212
23,49

Metersierpakket

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

Mysterious

art. 6240
19,99

Pijlpakket Air-attack 2

art. 2680
19,99

Midnight passion

art. 2310
19,99

Epic Shock XL

art. 2324
17,99
-28%
12,99

Typhoon

art. 6211
15,99

Thunder rockets 6 stuks

art. 2330
8,99
-22%
6,99

Thunder shock

art. 2325
2,99
-33%
1,99

Jumping jack

art. 2312
1,99

Epic Shocks

art. 2323
1,69
-30%
1,19

Grondbloemen

art. 2317
1,59
-19%
1,29

Mega bomb cracker

art. 2016
1,29
-23%
0,99
  BENCHMARKS  
Loading Time: Base Classes  0.0008
Controller Execution Time ( Products / Powerprices )  0.0893
  :  caff   QUERIES: 43  ()
0.0018   SELECT table_name FROM information_schema.tables WHERE table_schema 'public' 
0.0002   SET bytea_output=escape 
0.0007   SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('veneboerdrachten') 
0.0004  
            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 
'377' AND deleted 'f'
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'377'
         
0.0004  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'377'
            
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 '341'
            
ORDER BY name ASC
         
0.0004  
            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 
'341' IS NULL OR dealer_id '341' AND deleted 'f'
          
ORDER BY city ASC
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'377'
         
0.0003  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'377'
            
ORDER BY start_time ASC
             
0.0003  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '341'
         
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 
('341')
         
0.0004  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '341'
         
0.0002  
            SELECT id FROM product_sets WHERE id 
'11'
         
0.0004  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'11'
                 
0.0002  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'11'
             
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 '1178'
         
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 '1178'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1178'
         
0.0002  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0006  
               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 '475'
         
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 '475'
             
0.0003  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'475'
         
0.0002  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'18'
         
0.0006  
               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.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 '476'
             
0.0002  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'476'
         
0.0002  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'18'
         
0.0004  
               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.0004  
                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.0002  
            SELECT 
*
              
FROM product_assets
             WHERE product_id 
'1180'
         
0.0002  
              SELECT ps
.id,
                     
ps.name,
                     
ps.logo_path,
                     
ps.slug,
                     
ps.description
                FROM product_brands ps
               WHERE id 
'20'
         
0.0014  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'341'

                 
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 '341'
                                            
)
             
0.0027  
               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 (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
                
ORDER BY p.name
         
0.0026  
                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 (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
             
0.0006  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(2933202717221815191432212623)
         
0.0018  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
         
0.0020  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '341'
                                              
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 (48535118410814774815503045521461172190107516234155448336417019217616911743303091805471067156197117568947511674704544826931734781493293111171108523523942025732815314748011663383587031170349116868716011766913243103573311070116510772493531713073661651068151116454630517968636132168111734661084325216174472484107116316869037321935210581753633434673623271676923121177231340158108646015548719510764596992074883683691180194339326360476367107320636511783551571083413308107215035910801911591087495154316709474177107454911791852151781082145148486)
            
ORDER BY p.id        
         
0.0023  
            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 (9259233622342734322688250540503612404726202065206720662014207120252479248026182326202734258030407520542056205034212452206036072215408034423423911341980452320244959823232324351029933307341523623303802580608035299122063585341762053505912500362203624231722122570246924563606299723653305231225699323500251725168015354822312222220834472319230520162080298023102367353522213431251124676240231535503618246829922680268226842670935922224935302630299529994060802034806230407033013408340936058040298529542955296025502360352061303525299825188065621280102547254025432545807034602220362020752454617023302325232934452512621134202022237034369319103610354634902458347080462560) 
                AND 
alternative_products.article_number IN (9259233622342734322688250540503612404726202065206720662014207120252479248026182326202734258030407520542056205034212452206036072215408034423423911341980452320244959823232324351029933307341523623303802580608035299122063585341762053505912500362203624231722122570246924563606299723653305231225699323500251725168015354822312222220834472319230520162080298023102367353522213431251124676240231535503618246829922680268226842670935922224935302630299529994060802034806230407033013408340936058040298529542955296025502360352061303525299825188065621280102547254025432545807034602220362020752454617023302325232934452512621134202022237034369319103610354634902458347080462560)
              
0.0006  
                  SELECT id
parent_idnameimage_pathactiveslug
                    FROM product_categories
                   WHERE active 
't'
             
0.0003  
                    SELECT condition FROM admin_settings
                    WHERE name 
'overview_check_stocks'
         
0.0005  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'377' 
               
AND product_id IN (15847845910673554707031851844751451954766914773384825524725471531514606906991180)
         
0.0004  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'341' 
         
    
$_GET['dealer']   veneboerdrachten
  POST DATA  
Er is geen POST data
    
4,406,504 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  3.90.56.90
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=veneboerdrachten
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