SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305293 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305293 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016113,912248,128808,870555,826923,324036,674286,218284,414897,8039,285486,530055,939437,559075,756932,699161,437469,952443,234552,43908,349345,974169,321561,235051,792448,319596,626321,328816,134691,266343,834744,616363,223620,164830,485481,22632,50789,771223,68490,975531,256973,688556,993300,392858,648158,724300,35147,364147,877917,17458,534418,969794,936238,546136,428590,292851,425180,353121,553444,847629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000795s ]