Nieuwe Vuurwerktoppers online * Kortingen tot 85% * Vuurwerktoppers is al sinds jaren een begrip voor kwaliteitsvuurwerk tegen nette prijzen * Uniek, advies van Pyro Piet!

Profi final

art. 2999
269,99

Pyro Giant

art. 599
269,99
-19%
219,00

Excellent Box

art. 2993
129,99

Black celebration cracker 100.000

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

Thunder shock bulk

art. 2329
49,99
-20%
39,99

WTF BOX

art. 3470
39,99

Metersierpakket

art. 2980
22,99

Sierpakket Meter

art. 250
20,99

Thunder shock

art. 2325
2,99
-17%
2,49

Jumping Jack Azaro 144

art. 2252
1,99

Jumping jack

art. 2312
1,99

Epic Shocks

art. 2323
1,69
-41%
0,99

Grondbloemen

art. 2317
1,59
-38%
0,99
  BENCHMARKS  
Loading Time: Base Classes  0.0010
Controller Execution Time ( Products / Powerprices )  0.0468
  :  caff   QUERIES: 46  ()
0.0021   SELECT table_name FROM information_schema.tables WHERE table_schema 'public' 
0.0002   SET bytea_output=escape 
0.0011   SELECT id FROM delivery_addresses WHERE LOWER(webshop_slug) = LOWER('Rikxoort') 
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 
'83' AND deleted 'f'
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'83'
         
0.0009  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'83'
            
ORDER BY start_time ASC
             
0.0005  
              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 '87'
            
ORDER BY name ASC
         
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
                 
driving_time
                 
api_key
              FROM delivery_addresses
             WHERE 
'87' IS NULL OR dealer_id '87' AND deleted 'f'
          
ORDER BY city ASC
         
0.0003  
            SELECT phone_number
smsfaxfor_webshop
              FROM delivery_address_phone_numbers
             WHERE delivery_address_id 
'83'
         
0.0007  
              SELECT start_time
end_timeactiveid
                FROM delivery_address_time_zones
               WHERE delivery_address_id 
'83'
            
ORDER BY start_time ASC
             
0.0003  
            SELECT id
image_path FROM dealer_webshop_slider_images WHERE dealer_id '87'
         
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 
('87')
         
0.0004  
            SELECT product_id
maximum FROM dealer_product_maximums WHERE dealer_id '87'
         
0.0003  
            SELECT id FROM product_sets WHERE id 
'8'
         
0.0004  
                    SELECT product_id FROM product_set_products WHERE product_set_id 
'8'
                 
0.0002  
                SELECT id
image_pathproduct_iddescriptionsort_order
                FROM product_set_slides
                WHERE product_set_id 
'8'
             
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.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.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.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 '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.0002  
              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.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.0003  
            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.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 '1180'
         
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 '1180'
             
0.0003  
            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.0017  
                SELECT product_id 
AS id
                  FROM dealer_product_exceptions
                 WHERE dealer_id 
'87'

                 
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 '87'
                                            
)
             
0.0018  
               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 (184481550559607162582176541689569116748269317325746114763448030217236615154661668130367317416359810581752211675813122311584601554946091954593683691180339166367355301548159570177580549185178)
                
ORDER BY p.name
         
0.0021  
                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 (184481550559607162582176541689569116748269317325746114763448030217236615154661668130367317416359810581752211675813122311584601554946091954593683691180339166367355301548159570177580549185178)
             
0.0006  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(292232151424311816262317332027)
         
0.0009  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(184481550559607162582176541689569116748269317325746114763448030217236615154661668130367317416359810581752211675813122311584601554946091954593683691180339166367355301548159570177580549185178)
         
0.0012  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '87'
                                              
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 (184481550559607162582176541689569116748269317325746114763448030217236615154661668130367317416359810581752211675813122311584601554946091954593683691180339166367355301548159570177580549185178)
            
ORDER BY p.id        
         
0.0022  
            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 (925923405058020672071202524792480205070751135982323299322052991620550032317221229972312225293269525172516622726912016213729803431251129922682935922299529995992339245250240570525299825402543254513523252329222725129315010501250143470) 
                AND 
alternative_products.article_number IN (925923405058020672071202524792480205070751135982323299322052991620550032317221229972312225293269525172516622726912016213729803431251129922682935922299529995992339245250240570525299825402543254513523252329222725129315010501250143470)
              
0.0005  
                  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 
'83' 
               
AND product_id IN (1584593551851846731954826165821514601180)
         
0.0004  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'83' 
               
AND product_id '1167'
         
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 
('83')
         
0.0005  
            SELECT product_id 
              FROM delivery_address_local_stock_sales_only_products
             WHERE delivery_address_id 
'83' 
         
0.0006  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'87' 
         
    
$_GET['dealer']   Rikxoort
  POST DATA  
Er is geen POST data
    
2,950,848 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  52.23.234.7
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=Rikxoort
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