SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310804 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310804 [ RunTime:0.001864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266936,843934,355779,198888,147677,162418,882957,538250,545805,821559,380964,12248,460849,629684,54626,724036,923377,445821,958756,670812,256074,546972,314787,845293,602681,583581,764899,814733,1040782,504496,646592,1045027,599340,716799,679332,803801,419409,79623,64137,844180,729014,482954,135047,746926,266571,525107,615462,682006,580132,498542,862810,1027608,835790,218174,281094,196327,456496,343568,243642,27117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]