SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001271s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416750 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416750 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (191793,377932,772757,792539,140399,186564,62296,328113,350460,484851,680088,54370,682834,136595,452598,56350,551091,86160,53157,937367,895140,496129,20402,956315,850266,98204,177310,630602,410978,944960,575903,655398,15389,572610,1018249,154093,66138,232843,855276,1026080,130863,995728,266252,79943,829159,416945,589188,365829,497877,436750,883061,117698,273826,902315,977059,28864,601661,238481,109524,914054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416750 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000491s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416750 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000668s ]