DBM Wines ::   Admin Basket

UAT

Admin Basket : is empty
Customer : None selected

Admin Basket

Admin Basket is empty. Please search for wine and use the "Add to Admin Basket" button.


Bespoke Software Development BristolBespoke Software Development Bristol

Total EGC Queries 7

No.QueryRowsSSError CodesTime (seconds)
1 SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION' 0 Y Array ( [0] => 0 [1] => ) 0.0004911
2 SET time_zone = '+00:00' 0 Y Array ( [0] => 0 [1] => ) 0.0003269
3 select setting_value from customer_setting where setting_name = 'STD_DELIVERY' 0 Y Array ( [0] => 0 [1] => ) 0.0005710
4 SELECT * FROM location ORDER BY FIELD(row_status, 'OK', 'WITHDRAWN'), location_name 0 Y Array ( [0] => 0 [1] => ) 0.0007858
5 SELECT w.prod_style FROM ws_product w WHERE w.prod_status != 'WITHDRAWN' GROUP by w.prod_style ORDER by FIELD( w.prod_style ,'RED','WHITE','PINK','SPARKLING','FORTIFIED','DESSERT','XSPIRIT','BEER','CIDER','ASOFT','GIFT','TICKET','PACKAGING' ) 0 Y Array ( [0] => 0 [1] => ) 0.0069389
6 SELECT distinct ET.ethic_name, ET.ethic_type_id, ET.ethic_order FROM ws_product p JOIN wine_has_ethics WHE ON p.prod_id = WHE.prod_id JOIN ethic_type ET ON ET.ethic_type_id = WHE.ethic_type_id WHERE ET.ethic_status = 'OK' AND ET.ethic_type_id NOT IN (3,2,6,7) ORDER BY ET.ethic_order 0 Y Array ( [0] => 0 [1] => ) 0.0261259
7 SELECT w.prod_country FROM ws_product w WHERE w.prod_status != 'WITHDRAWN' GROUP by w.prod_country ORDER by FIELD( w.prod_country ,'FRANCE','ITALY','SPAIN','PORTUGAL','GERMANY','ENGLAND','AUSTRIA','AUSTRALIA','NZ','SOUTHAFRICA','CALIFORNIA','CHILE','ARGENTINA','OTHER' ) 0 Y Array ( [0] => 0 [1] => ) 0.0070760
Total time: 0.0423157