SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311011 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311011 [ RunTime:0.001550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (902220,302391,404404,51867,849423,919451,433438,378225,165660,197545,888617,548198,952771,941485,136462,208786,961646,151063,307718,281480,637518,448959,375063,485125,217936,190268,469515,344368,394460,49404,1038487,400264,823783,833513,111659,840215,750260,500202,225853,558852,966618,290179,720538,572978,996625,332416,298848,505665,103673,593904,766715,1022359,209083,311749,1007704,203279,396430,620231,643937,564446) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003094s ]