Nieuwe Vuurwerktoppers online * Online bestellen = gratis vuurwerk en kans op Ferrari rijden! * Vuurwerktoppers is al sinds jaren een begrip voor kwaliteitsvuurwerk tegen nette prijzen * Uniek, advies van Pyro Piet!

b

PowerPrijzen

Profi final

art. 2999
269,99
-30%
189,99

Pyro Giant

art. 599
269,99
-30%
189,99

Destroyer

art. 2463
144,99
-17%
120,00

Brutal Leader

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

Spring Meister

art. 8065
140,00
-29%
99,99

Dream planet

art. 2320
99,99
-10%
89,99

Profi trio

art. 2994
149,99
-35%
97,50

Eagle glitter Master

art. 598
249,99
-72%
69,99

Exclusive Dream

art. 730
84,99
-53%
39,99

Night hunter

art. 2315
84,99

Sierpakket Silver Shadow

art. 515
79,99
-7%
74,34

Great anniversary

art. 7080
79,99

Quattro Pack

art. 3480
79,99

Innovation

art. 3305
110,00
-36%
69,99

Great sphinx

art. 3624
79,99

Black celebration cracker 100.000

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

Professional pijlpakket 11 st

art. 2630
62,49
-4%
59,99

Golden Globe

art. 6140
59,99
-38%
37,49

Ghost Rider

art. 6150
59,99
-38%
37,49

Escape

art. 6160
59,99
-38%
37,49

Trouble Shooter

art. 6155
59,99
-38%
37,49

Gold rush

art. 6220
59,99

Barracuda

art. 6145
79,99
-53%
37,49

Salvo Mover

art. 7038
57,99
-53%
27,50

Various Battery

art. 3436
59,99
-13%
52,49

Rollercoaster

art. 744
49,99

Thunder shock bulk

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

Palm Trophy

art. 720
45,00

Illusion

art. 2469
44,99
-33%
29,99

Angry grizzly

art. 3432
42,49
-6%
39,99

Detonator

art. 712
40,00
-6%
37,50

Sierpakket blue shadow

art. 505
39,99
-12%
35,12

Revolution

art. 3301
60,00
-38%
37,50

Pijlpakket Air-attack 4

art. 2682
55,00
-27%
39,99

Rocket shooter 2

art. 3409
39,49
-24%
29,99

Colorful Crosette

art. 5070
34,99

Willow fan

art. 3490
32,50

Spitfire

art. 745
32,50

Venetian Wave

art. 3625
65,00
-50%
32,49

Color Mines

art. 5085
65,00
-38%
39,99

X 60 siercake 18 schots

art. 3560
38,90
-55%
17,50

Record breaker

art. 6230
24,99
-20%
19,99

Magnolia Dreams

art. 705
23,50

Magnolia spectacle

art. 2305
23,50

Stargate

art. 6212
23,49

Metersierpakket

art. 2980
22,99
-13%
19,99

Light Storm

art. 6227
22,50
-11%
20,00

Velvet Rain

art. 560
20,00
-30%
13,99

Midnight passion

art. 2310
19,99

Mysterious

art. 6240
19,99

Pijlpakket Air-attack 2

art. 2680
19,99

Wunder flute

art. 8046
45,00
-56%
19,99

Blitz Nachte

art. 8030
25,00
-20%
19,99

Sierpakket draagtas

art. 2954
22,50
-24%
16,99

Epic Shock XL

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

Missile base 300

art. 3431
16,49
-9%
14,99

Typhoon

art. 6211
15,99
-6%
14,99

Space Power

art. 710
27,50

Light Express

art. 3548
15,28
-15%
12,99

Whistling wizzard

art. 6225
12,99

Whistle Block

art. 715
12,99

Chrysantium Legend

art. 3421
8,99
-17%
7,49

Thunder rockets 6 stuks

art. 2330
8,99
-33%
5,99

Tolle lola 6 stuks

art. 2227
7,79
-4%
7,49

Thunder shock

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

Big jumping jack

art. 2313
2,95

Jumping jack

art. 2312
1,99

Epic Shocks

art. 2323
1,69
-47%
0,89

Grondbloemen

art. 2317
1,59
-21%
1,25

Bombers

art. 2017
1,49

Mega bomb cracker

art. 2016
1,29

Mega bomb cracker MAX.

art. 20162
0,99
-30%
0,69
  BENCHMARKS  
Loading Time: Base Classes  0.0005
Controller Execution Time ( Products / Powerprices )  0.1190
  :  caff   QUERIES: 28  ()
0.0016   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('vesta-vuurwerk') 
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 
'4' AND deleted 'f'
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'4'
         
0.0008  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'4'
            
ORDER BY start_time ASC
             
0.0004  
              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 '7'
            
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 
'7' IS NULL OR dealer_id '7' AND deleted 'f'
          
ORDER BY city ASC
         
0.0002  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'4'
         
0.0007  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'4'
            
ORDER BY start_time ASC
             
0.0003  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '7'
         
0.0004  
            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 
('7')
         
0.0004  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '7'
         
0.0003  
            SELECT id FROM product_sets WHERE id 
'13'
         
0.0005  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'13'
                 
0.0003  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'13'
             
0.0027  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'7'

                 
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 '7'
                                            
)
             
0.0031  
               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 (48535118434610814775504811091110255214610751172190162341554483364170192176169299117427633034530960554118034823654715610676131971175641475689493116747045448269317314947810791171108523523960142025730670032815314748033811662023585657036952261170106911686876422441602595536441721176691468357331110010701165107735317124963536630716510681511164123234754617930561663668618136168111734667061084106021617454247223322033455814410711684716901103223373105835221917534336359646728736216769231223111773401586885941086356460155494110419548745810764596997022073684883693391943603445954634763674921073107820636511786377041083413222247183107231315035935410805974796141915484951087154570316709474621177106169610745491179185215178145148270486612)
                
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 (48535118434610814775504811091110255214610751172190162341554483364170192176169299117427633034530960554118034823654715610676131971175641475689493116747045448269317314947810791171108523523960142025730670032815314748033811662023585657036952261170106911686876422441602595536441721176691468357331110010701165107735317124963536630716510681511164123234754617930561663668618136168111734667061084106021617454247223322033455814410711684716901103223373105835221917534336359646728736216769231223111773401586885941086356460155494110419548745810764596997022073684883693391943603445954634763674921073107820636511786377041083413222247183107231315035935410805974796141915484951087154570316709474621177106169610745491179185215178145148270486612)
             
0.0006  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(293311202726171822151924233214342131)
         
0.0037  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(48535118434610814775504811091110255214610751172190162341554483364170192176169299117427633034530960554118034823654715610676131971175641475689493116747045448269317314947810791171108523523960142025730670032815314748033811662023585657036952261170106911686876422441602595536441721176691468357331110010701165107735317124963536630716510681511164123234754617930561663668618136168111734667061084106021617454247223322033455814410711684716901103223373105835221917534336359646728736216769231223111773401586885941086356460155494110419548745810764596997022073684883693391943603445954634763674921073107820636511786377041083413222247183107231315035935410805974796141915484951087154570316709474621177106169610745491179185215178145148270486612)
         
0.0025  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '7'
                                              
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 (48535118434610814775504811091110255214610751172190162341554483364170192176169299117427633034530960554118034823654715610676131971175641475689493116747045448269317314947810791171108523523960142025730670032815314748033811662023585657036952261170106911686876422441602595536441721176691468357331110010701165107735317124963536630716510681511164123234754617930561663668618136168111734667061084106021617454247223322033455814410711684716901103223373105835221917534336359646728736216769231223111773401586885941086356460155494110419548745810764596997022073684883693391943603445954634763674921073107820636511786377041083413222247183107231315035935410805974796141915484951087154570316709474621177106169610745491179185215178145148270486612)
            
ORDER BY p.id        
         
0.0020  
                SELECT 
*
                  
FROM dealer_product_prices
                 WHERE product_id
                        IN 
(36636711772333434874743451068106922210792571060117425910862191561581541551621651601164362235458492299614123214814914730927627010774134945421172168108710784884791061706709117836547868711677004591067348644454236307612107336128748636354942010855464953464636933444706951100553703244185167686216352117148110744853561841903681084681175359357107054817111651179116863547570214554156537357019547610751703121733416914773316211175642215550338339340207369105810713283542064804826882496163605524722394833053061102117061320236460146811041975941911925971945955964671072116624722063655868946610911103692547358179176177178108110831691176150493351696144153151460172226223641174347690146107631623155460570411733136374713306993531080334180183181)
                   AND 
dealer_id '7'
             
0.0050  
            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 (92592336223230342734322688614525052507299029874050231336124045404726202065206720142025247926182326202780304075201770655018595936205420562050342150705085245220607075503636072215408024533442246324632712911341980452320244959870622323232461607303307323734155922362802550458060803529912206358562059126150233350036140622050393600708036244065231722122570246924563606299723653305323223122569932350025172516801535482231622722222208344723197052305755201620162128208013729802310236722213431251124676240231535503615361872024682992268026822684267093592222493530246026302995299929944060599802034806230407033013409341074436055937038804054062107702985505295429555202960510515255023606130701526907101112998251850877458065621280102547254025432545807034602220362020757070245450512004233023252329222734043401750251261556211202223703436931910560362536103407715622535463490245880463560256025642562) 
                AND 
alternative_products.article_number IN (92592336223230342734322688614525052507299029874050231336124045404726202065206720142025247926182326202780304075201770655018595936205420562050342150705085245220607075503636072215408024533442246324632712911341980452320244959870622323232461607303307323734155922362802550458060803529912206358562059126150233350036140622050393600708036244065231722122570246924563606299723653305323223122569932350025172516801535482231622722222208344723197052305755201620162128208013729802310236722213431251124676240231535503615361872024682992268026822684267093592222493530246026302995299929944060599802034806230407033013409341074436055937038804054062107702985505295429555202960510515255023606130701526907101112998251850877458065621280102547254025432545807034602220362020757070245450512004233023252329222734043401750251261556211202223703436931910560362536103407715622535463490245880463560256025642562)
              
0.0005  
                  SELECT id
parent_idnameimage_pathactiveslug
                    FROM product_categories
                   WHERE active 
't'
             
0.0002  
                    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 
'4' 
               
AND product_id IN (487345106015836245861430927627047970647811674591067348644346344470553703185216485184357548635475145541195476312691477642338339206482688616552472483305110220259419159663611036925471531514601723476903166057046374716991080334)
         
0.0005  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'7' 
         
    
$_GET['dealer']   vesta-vuurwerk
  POST DATA  
Er is geen POST data
    
6,226,240 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=vesta-vuurwerk
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