Vuurwerkverkoopdagen 28-29-31 december 2018! Zondag 30 december open van 12 uur tot 17 uur, u kunt op zondag geen vuurwerk meenemen wel bestellen!! Mooie potten voor knallende prijzen. Op 28 en 29 december hebben wij weer het knalrad in de winkel!

Vuurwerk kopen bij Floral Design in Rosmalen

Het mooiste vuurwerk voor een goede prijs vind je bij Floral Design. We hebben een groot assortiment met veelzijdige producten. Of het nu gaat om prachtige cakes, mooie pijlen, sensationele compoundboxen of stoere thundershocks. Bij Floral Design stellen we jaarlijks een geweldig assortiment aan knal- en siervuurwerk samen dat voor ieder wat wils kent.

Tijdens de verkoopdagen hebben we heel veel extra knallende aanbiedingen! In onze winkel bent u welkom om uw vragen te stellen en een lekkere warme oliebol te komen eten!

Bestellen kan sinds een paar jaar gemakkelijk via deze site. Maar veel van onze klanten zien we al jaren in de vuurwerkwinkel. Daar kan iedereen gemakkelijk zijn bestelling doen of even om advies vragen. Wanneer u besteld heeft in de voorverkoop, kunt u vanaf 28 december uw vuurwerk op komen halen in de winkel.

Vuurwerk kopen Nuland, Kerkdriel, Hedel, Geffen, Berlicum, Maaskantje, Den Dungen en Sint-Michielsgestel

Den Bosch ligt op een zeer korte afstand van Rosmalen, maar het is vaak veel gemakkelijker om niet de stad in te moeten. Rosmalen ligt veel dichterbij Nuland, Kerkdriel, Hedel, Geffen, Berlicum, Maaskantje, Den Dungen en Sint-Michielsgestel. Dus veel van onze klanten komen daar vandaan.

PowerPrijzen

Profi final

art. 2999
269,99
-27%
197,99

Excellent Box

art. 2993
129,99
-25%
97,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
-30%
49,00

Gold rush

art. 6220
59,99
-4%
57,50

Thunder shock bulk

art. 2329
49,99
-48%
25,99

WTF BOX

art. 3470
39,99

Sierpakket blue shadow

art. 505
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
-4%
22,50

Metersierpakket

art. 2980
22,99
-43%
12,99

Pijlpakket Air-attack 2

art. 2680
19,99

Midnight passion

art. 2310
19,99

Mysterious

art. 6240
19,99

Epic Shock XL

art. 2324
17,99
-44%
9,99

Typhoon

art. 6211
15,99

Thunder rockets 6 stuks

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

Thunder shock

art. 2325
2,99
-47%
1,59

Jumping jack

art. 2312
1,99
-25%
1,49

Epic Shocks

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

Grondbloemen

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

Mega bomb cracker

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

                 
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 '13'
                                            
)
             
0.0028  
               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 (4853511844774815503045521461172107519016234155448317019217616911743303091805471067156197475117568911674704544824781731493113291171108523523942025730615332814748033811667031170116868716025911766913243103573311070116510772493531713073661651511068116430554617968632168111734661084325174472484144107116816369022337310582193521753434673271673121177231340158108659446015519548745910766992074883683691180339194326476367107810731178355704157108341330810721501911591087495154316709474177107454911791852642151781082145148)
                
ORDER BY p.name
         
0.0028  
                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 (4853511844774815503045521461172107519016234155448317019217616911743303091805471067156197475117568911674704544824781731493113291171108523523942025730615332814748033811667031170116868716025911766913243103573311070116510772493531713073661651511068116430554617968632168111734661084325174472484144107116816369022337310582193521753434673271673121177231340158108659446015519548745910766992074883683691180339194326476367107810731178355704157108341330810721501911591087495154316709474177107454911791852642151781082145148)
             
0.0006  
              SELECT 
*
                
FROM product_brands
               WHERE id IN 
(293320271722181514322126)
         
0.0014  
            SELECT 
*
              
FROM product_assets
             WHERE product_id IN 
(4853511844774815503045521461172107519016234155448317019217616911743303091805471067156197475117568911674704544824781731493113291171108523523942025730615332814748033811667031170116868716025911766913243103573311070116510772493531713073661651511068116430554617968632168111734661084325174472484144107116816369022337310582193521753434673271673121177231340158108659446015519548745910766992074883683691180339194326476367107810731178355704157108341330810721501911591087495154316709474177107454911791852642151781082145148)
         
0.0020  
            SELECT p
.id,
                  ( CASE
                     
WHEN p.power_price
                       THEN coalesce
( ( SELECT pp.price
                                        FROM powerprices 
AS pp
                                        WHERE pp
.dealer_id '13'
                                              
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 (4853511844774815503045521461172107519016234155448317019217616911743303091805471067156197475117568911674704544824781731493113291171108523523942025730615332814748033811667031170116868716025911766913243103573311070116510772493531713073661651511068116430554617968632168111734661084325174472484144107116816369022337310582193521753434673271673121177231340158108659446015519548745910766992074883683691180339194326476367107810731178355704157108341330810721501911591087495154316709474177107454911791852642151781082145148)
            
ORDER BY p.id        
         
0.0012  
                SELECT 
*
                  
FROM dealer_product_prices
                 WHERE product_id
                        IN 
(3663671177343487474106825711742591086219156158157154159155162163165160116431123514814914730910774131172168108710784883107091178264478687116745910673253554543071073484549420108510825463244954707031851676863521171481107448518419036810846811753571070171116511791168475145373195476107532917031217334169147733111752155503383393402073691058107132848048224955247223948330430530611701975941911921944671072326116632768946654717917617717810831691176150351144153151460223321174690308146107631623155470411733306993531180180)
                   AND 
dealer_id '13'
             
0.0037  
            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 (925923362234273432268825054050361240454047262020652067206620142071202524792480261823262027342540752054205620503421245220603607221540802453344234239113419928232024495982323232435102993330734152362330329912206358534176205350591262203624231722122570245636062997236533052312256993235002517251635482231222222083447231923052016208029802310236735352221343125112467624023153550361824682992268026822684267093592222493530299529994060348062304070330134083409341036052985505295429552960255023603520613035252998251862122547254025432545346022203620207524542004233023252329340134452512621134202022237034369319103625361035463490245834702560) 
                AND 
alternative_products.article_number IN (925923362234273432268825054050361240454047262020652067206620142071202524792480261823262027342540752054205620503421245220603607221540802453344234239113419928232024495982323232435102993330734152362330329912206358534176205350591262203624231722122570245636062997236533052312256993235002517251635482231222222083447231923052016208029802310236735352221343125112467624023153550361824682992268026822684267093592222493530299529994060348062304070330134083409341036052985505295429552960255023603520613035252998251862122547254025432545346022203620207524542004233023252329340134452512621134202022237034369319103625361035463490245834702560)
              
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.0004  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'10' 
               
AND product_id IN (15847845910673554707031851844751451954766914773384825524725945471531514606906991180)
         
0.0004  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'10' 
               
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 
('10')
         
0.0005  
            SELECT product_id 
              FROM delivery_address_local_stock_sales_only_products
             WHERE delivery_address_id 
'10' 
         
0.0005  
            SELECT
                p
.id,
                
p.article_number,
                
p.articles_per_box,
                
p.name,
                
p.gross_weight_per_box,
                
p.weight_per_article,
                
coalesce(s.amount_unpacked0) AS article_amount
                FROM products 
AS p
            LEFT JOIN delivery_address_storages 
AS s
                ON s
.product_id p.id
            WHERE
                    s
.delivery_address_id '10'
                
AND ('1167' IS NULL OR p.id '1167')
         
0.0018  
            SELECT to_timestamp
(datz.start_time) :: TIMESTAMP AS start_timeto_timestamp(datz.end_time) :: TIMESTAMP AS end_timedatz.idSUM(coi.quantity) AS qty
              FROM delivery_address_time_zones datz
              
              JOIN customer_orders co
                ON co
.time_zone_id datz.id
                
              JOIN customer_order_items coi
                ON coi
.order_id co.id  
                
             WHERE datz
.delivery_address_id '10'
               
AND EXTRACT(YEAR FROM to_timestamp(datz.start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_DATE)  
               AND 
co.pick_up_time IS NULL
               
AND co.paid
               
AND coi.product_revision_id IN (SELECT id 
                                                 FROM product_revisions
                                                WHERE product_id 
'1167')
          
GROUP BY datz.start_timedatz.end_timedatz.id
          ORDER BY datz
.start_time ASC                 
         
0.0041  
            SELECT SUM
(doi.quantity pr.articles_per_box) AS qtydor.preferred_delivery_timedor.estimated_time_of_arrival
              FROM dealer_orders dor
              
              JOIN dealer_order_items doi
                ON doi
.order_id dor.id
              
              JOIN product_revisions pr 
                ON pr
.id doi.product_revision_id
                 
             WHERE dor
.status NOT IN ('delivered''submitted''seen')
               AND 
dor.delivery_address_id '10'
               
AND dor.preferred_delivery_time IS NOT NULL
               
AND dor.checked_in FALSE
               
AND dor.is_dummy_order FALSE
               
AND dor.is_combined_order FALSE
               
AND pr.product_id '1167'

              
          
GROUP BY dor.preferred_delivery_timedor.estimated_time_of_arrival                              
         
0.0006  
            SELECT to_timestamp
(start_time) :: TIMESTAMP AS start_timeto_timestamp(end_time) :: TIMESTAMP AS end_timeid
              FROM delivery_address_time_zones
             WHERE delivery_address_id 
'10'  
               
AND EXTRACT(YEAR FROM to_timestamp(start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_TIMESTAMP)
               
          
ORDER BY start_time ASC  
         
0.0003  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'10' 
               
AND product_id '552'
         
0.0004  
            SELECT product_id 
              FROM delivery_address_local_stock_sales_only_products
             WHERE delivery_address_id 
'10' 
         
0.0004  
            SELECT
                p
.id,
                
p.article_number,
                
p.articles_per_box,
                
p.name,
                
p.gross_weight_per_box,
                
p.weight_per_article,
                
coalesce(s.amount_unpacked0) AS article_amount
                FROM products 
AS p
            LEFT JOIN delivery_address_storages 
AS s
                ON s
.product_id p.id
            WHERE
                    s
.delivery_address_id '10'
                
AND ('552' IS NULL OR p.id '552')
         
0.0016  
            SELECT to_timestamp
(datz.start_time) :: TIMESTAMP AS start_timeto_timestamp(datz.end_time) :: TIMESTAMP AS end_timedatz.idSUM(coi.quantity) AS qty
              FROM delivery_address_time_zones datz
              
              JOIN customer_orders co
                ON co
.time_zone_id datz.id
                
              JOIN customer_order_items coi
                ON coi
.order_id co.id  
                
             WHERE datz
.delivery_address_id '10'
               
AND EXTRACT(YEAR FROM to_timestamp(datz.start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_DATE)  
               AND 
co.pick_up_time IS NULL
               
AND co.paid
               
AND coi.product_revision_id IN (SELECT id 
                                                 FROM product_revisions
                                                WHERE product_id 
'552')
          
GROUP BY datz.start_timedatz.end_timedatz.id
          ORDER BY datz
.start_time ASC                 
         
0.0038  
            SELECT SUM
(doi.quantity pr.articles_per_box) AS qtydor.preferred_delivery_timedor.estimated_time_of_arrival
              FROM dealer_orders dor
              
              JOIN dealer_order_items doi
                ON doi
.order_id dor.id
              
              JOIN product_revisions pr 
                ON pr
.id doi.product_revision_id
                 
             WHERE dor
.status NOT IN ('delivered''submitted''seen')
               AND 
dor.delivery_address_id '10'
               
AND dor.preferred_delivery_time IS NOT NULL
               
AND dor.checked_in FALSE
               
AND dor.is_dummy_order FALSE
               
AND dor.is_combined_order FALSE
               
AND pr.product_id '552'

              
          
GROUP BY dor.preferred_delivery_timedor.estimated_time_of_arrival                              
         
0.0006  
            SELECT to_timestamp
(start_time) :: TIMESTAMP AS start_timeto_timestamp(end_time) :: TIMESTAMP AS end_timeid
              FROM delivery_address_time_zones
             WHERE delivery_address_id 
'10'  
               
AND EXTRACT(YEAR FROM to_timestamp(start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_TIMESTAMP)
               
          
ORDER BY start_time ASC  
         
0.0003  
            SELECT product_id 
              FROM delivery_address_manual_out_of_stock_products
             WHERE delivery_address_id 
'10' 
               
AND product_id '355'
         
0.0004  
            SELECT product_id 
              FROM delivery_address_local_stock_sales_only_products
             WHERE delivery_address_id 
'10' 
         
0.0004  
            SELECT
                p
.id,
                
p.article_number,
                
p.articles_per_box,
                
p.name,
                
p.gross_weight_per_box,
                
p.weight_per_article,
                
coalesce(s.amount_unpacked0) AS article_amount
                FROM products 
AS p
            LEFT JOIN delivery_address_storages 
AS s
                ON s
.product_id p.id
            WHERE
                    s
.delivery_address_id '10'
                
AND ('355' IS NULL OR p.id '355')
         
0.0018  
            SELECT to_timestamp
(datz.start_time) :: TIMESTAMP AS start_timeto_timestamp(datz.end_time) :: TIMESTAMP AS end_timedatz.idSUM(coi.quantity) AS qty
              FROM delivery_address_time_zones datz
              
              JOIN customer_orders co
                ON co
.time_zone_id datz.id
                
              JOIN customer_order_items coi
                ON coi
.order_id co.id  
                
             WHERE datz
.delivery_address_id '10'
               
AND EXTRACT(YEAR FROM to_timestamp(datz.start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_DATE)  
               AND 
co.pick_up_time IS NULL
               
AND co.paid
               
AND coi.product_revision_id IN (SELECT id 
                                                 FROM product_revisions
                                                WHERE product_id 
'355')
          
GROUP BY datz.start_timedatz.end_timedatz.id
          ORDER BY datz
.start_time ASC                 
         
0.0053  
            SELECT SUM
(doi.quantity pr.articles_per_box) AS qtydor.preferred_delivery_timedor.estimated_time_of_arrival
              FROM dealer_orders dor
              
              JOIN dealer_order_items doi
                ON doi
.order_id dor.id
              
              JOIN product_revisions pr 
                ON pr
.id doi.product_revision_id
                 
             WHERE dor
.status NOT IN ('delivered''submitted''seen')
               AND 
dor.delivery_address_id '10'
               
AND dor.preferred_delivery_time IS NOT NULL
               
AND dor.checked_in FALSE
               
AND dor.is_dummy_order FALSE
               
AND dor.is_combined_order FALSE
               
AND pr.product_id '355'

              
          
GROUP BY dor.preferred_delivery_timedor.estimated_time_of_arrival                              
         
0.0009  
            SELECT to_timestamp
(start_time) :: TIMESTAMP AS start_timeto_timestamp(end_time) :: TIMESTAMP AS end_timeid
              FROM delivery_address_time_zones
             WHERE delivery_address_id 
'10'  
               
AND EXTRACT(YEAR FROM to_timestamp(start_time) :: TIMESTAMP) = EXTRACT(YEAR FROM CURRENT_TIMESTAMP)
               
          
ORDER BY start_time ASC  
         
0.0006  
            SELECT is_platinum
              FROM dealers 
             WHERE id 
'13' 
         
    
$_GET['dealer']   floraldesign
  POST DATA  
Er is geen POST data
    
4,680,600 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  18.234.236.14
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=floraldesign
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