DBM Wines ::   DBM Wines Administration

UAT

Admin Basket : is empty
Customer : None selected
  • Back to the Website

    • 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 email address, you will be emailed a password reset link.

    Email Address
     

    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.0003979
    2 SET time_zone = '+00:00' 0 Y Array ( [0] => 0 [1] => ) 0.0003898
    3 select setting_value from customer_setting where setting_name = 'STD_DELIVERY' 0 Y Array ( [0] => 0 [1] => ) 0.0007691
    4 SELECT * FROM location ORDER BY FIELD(row_status, 'OK', 'WITHDRAWN'), location_name 0 Y Array ( [0] => 0 [1] => ) 0.0009501
    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.0073678
    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.0322649
    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.0070579
    Total time: 0.0491977