DBM Wines Administration - DBM Wines - Your Personal Wine Merchant

:: DBM Wines Administration

UAT

Admin Basket : is empty
Customer : None selected

You need to be signed in to access this part of the site. Enter your user code and password below and then we'll proceed.

This web-application is operated on behalf of DBM Wines. Only authorised users are entitled to connect and/or login to this computer system.

Unauthorised use of this system is a criminal offence.

Please enter your user code and password.

Total EGC Queries 7

No.	Query	Rows	SS	Error Codes	Time (seconds)
1	SET SESSION sql_mode = 'NO_ENGINE_SUBSTITUTION'	0	Y	Array ( [0] => 0 [1] => )	0.0003328
2	SET time_zone = '+00:00'	0	Y	Array ( [0] => 0 [1] => )	0.0002971
3	select setting_value from customer_setting where setting_name = 'STD_DELIVERY'	0	Y	Array ( [0] => 0 [1] => )	0.0006151
4	SELECT * FROM location ORDER BY FIELD(row_status, 'OK', 'WITHDRAWN'), location_name	0	Y	Array ( [0] => 0 [1] => )	0.0007010
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.0113111
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.0622761
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.0096762
Total time:					0.0852094