SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419751 LIMIT 1 [ RunTime:0.000275s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419751 [ RunTime:0.002262s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (655072,349711,574884,120139,883207,12582,355037,737052,918182,517010,415356,908561,743701,437037,1047193,367969,872423,1036037,140950,319470,270372,964069,343360,433733,529865,1026960,390107,382015,634509,453022,462546,957103,221471,1027379,40066,22861,21906,319330,362951,621616,38587,919335,87274,147778,114540,8458,851256,367339,635814,662094,566308,1003282,512972,611298,67726,443191,447168,108628,393557,921864) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419751 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419751 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]