VUURWERK KOPEN IN LELYSTAD, ALMERE BIJ LELYVUURWERK!! * Beste prijs kwaliteit verhouding! *

PowerPrijzen

Profi final

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

Excellent Box

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

Brutal Leader

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

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
-43%
39,95

Gold rush

art. 6220
59,99

Thunder shock bulk

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

WTF BOX

art. 3470
39,99

Willow fan

art. 3490
32,50

Record breaker

art. 6230
24,99
-28%
17,99

Magnolia spectacle

art. 2305
23,50

Stargate

art. 6212
23,49

Metersierpakket

art. 2980
22,99
-31%
15,95

Midnight passion

art. 2310
19,99
-10%
17,95

Pijlpakket Air-attack 2

art. 2680
19,99
-20%
15,95

Mysterious

art. 6240
19,99

Epic Shock XL

art. 2324
17,99
-22%
13,95

Typhoon

art. 6211
15,99
-19%
12,99

Thunder rockets 6 stuks

art. 2330
8,99
-34%
5,95

Thunder shock

art. 2325
2,99
-40%
1,79

Jumping jack

art. 2312
1,99
-15%
1,69

Epic Shocks

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

Grondbloemen

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

Mega bomb cracker

art. 2016
1,29
-23%
0,99
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Products / Powerprices )  0.0832
  :  caff   QUERIES: 54  ()
0.0019   SELECT table_name FROM information_schema.tables WHERE table_schema 'public' 
0.0002   SET bytea_output=escape 
0.0008   SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('lelystad') 
0.0006  
            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 
'263' AND deleted 'f'
         
0.0005  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'263'
         
0.0009  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'263'
            
ORDER BY start_time ASC
             
0.0007  
              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 '147'
            
ORDER BY name ASC
         
0.0008  
            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 
'147' IS NULL OR dealer_id '147' AND deleted 'f'
          
ORDER BY city ASC
         
0.0005  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'172'
         
0.0011  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'172'
            
ORDER BY start_time ASC
             
0.0004  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'263'
         
0.0008  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'263'
            
ORDER BY start_time ASC
             
0.0004  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'170'
         
0.0011  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'170'
            
ORDER BY start_time ASC
             
0.0004  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'292'
         
0.0005  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'292'
            
ORDER BY start_time ASC
             
0.0002  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '147'
         
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 
('147')
         
0.0004  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '147'
         
0.0004  
            SELECT id FROM product_sets WHERE id 
'1'
         
0.0004  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'1'
                 
0.0002  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'1'
             
0.0005  
               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.0003  
               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.0005  
               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.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 '1178'
         
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 '1178'
             
0.0002  
            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.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 '476'
         
0.0003  
                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.0012  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'147'

                 
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 '147'
                                            
)
             
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 (48518447727348155214610751901625544831701761693303091805471067156197475689117547045411674822276934781731493111079117110854202571533281474803381166358703695226551117011686872596913101070116517124936630716515110681164305546686321681361466108451617447248427422014410711681636902231058219175343467167312692231340158688108646015548719545910766992073684883691180194339326476367107320611782243551571083413308107215010986141911594951087154709316474177621107454951711791851781082145148486)
                
ORDER BY p.name
         
0.0040  
                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 (48518447727348155214610751901625544831701761693303091805471067156197475689117547045411674822276934781731493111079117110854202571533281474803381166358703695226551117011686872596913101070116517124936630716515110681164305546686321681361466108451617447248427422014410711681636902231058219175343467167312692231340158688108646015548719545910766992073684883691180194339326476367107320611782243551571083413308107215010986141911594951087154709316474177621107454951711791851781082145148486)
             
0.0005  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(2920271718221532142319262133)
         
0.0018  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(48518447727348155214610751901625544831701761693303091805471067156197475689117547045411674822276934781731493111079117110854202571533281474803381166358703695226551117011686872596913101070116517124936630716515110681164305546686321681361466108451617447248427422014410711681636902231058219175343467167312692231340158688108646015548719545910766992073684883691180194339326476367107320611782243551571083413308107215010986141911594951087154709316474177621107454951711791851781082145148486)
         
0.0027  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '147'
                                              
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 (48518447727348155214610751901625544831701761693303091805471067156197475689117547045411674822276934781731493111079117110854202571533281474803381166358703695226551117011686872596913101070116517124936630716515110681164305546686321681361466108451617447248427422014410711681636902231058219175343467167312692231340158688108646015548719545910766992073684883691180194339326476367107320611782243551571083413308107215010986141911594951087154709316474177621107454951711791851781082145148486)
            
ORDER BY p.id        
         
0.0055  
            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 (9259233427343226882505298740504045404726202065206720662014207120252479248026182027342559520542056205034212060221540803442342391134195078232024495982323232429933307341550752362330380258060299122063585341762059125003622050393624231722122570360629972365330523122569932350025172516223122222208344723192305201629802310236722213431251162402315361536182680268226842670935922224935302630299529992994406034806230330134093605298529542960255023603520613026902998251880655946212801025402543254597397434602220207520042330232523293402340434053401344525122996621134202022237034369319103546349034702560) 
                AND 
alternative_products.article_number IN (9259233427343226882505298740504045404726202065206720662014207120252479248026182027342559520542056205034212060221540803442342391134195078232024495982323232429933307341550752362330380258060299122063585341762059125003622050393624231722122570360629972365330523122569932350025172516223122222208344723192305201629802310236722213431251162402315361536182680268226842670935922224935302630299529992994406034806230330134093605298529542960255023603520613026902998251880655946212801025402543254597397434602220207520042330232523293402340434053401344525122996621134202022237034369319103546349034702560)
              
0.0004  
                  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 
'263' 
               
AND product_id IN (15861447845910673554707031851844751451954766914773384825524725471531514606906991180)
         
0.0003  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'263' 
               
AND product_id '690'
         
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
                 
max_kilo_per_timezone
                 
max_orders_per_timezone
                 
email_address
                 
webshop_order_cc_email_address
                 
webshop_twitter
                 
webshop_facebook
                 
name
                 
logo_path
                 
webshop_resell_enabled
                 
webshop_resell_discount_percentage
                 
driving_time
              FROM delivery_addresses
             WHERE id IN 
('263')
         
0.0004  
            SELECT product_id 
              FROM delivery_address_local_stock_sales_only_products
             WHERE delivery_address_id 
'263' 
         
0.0003  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'147' 
         
    
$_GET['dealer']   lelystad
  POST DATA  
Er is geen POST data
    
4,784,128 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=lelystad
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