SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118634 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118634 [ RunTime:0.001583s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (455615,456136,197302,824568,486233,80418,622560,1003375,274852,754301,844968,801059,441850,337592,333256,370369,245612,921747,187620,186902,706593,1015056,268274,464705,778501,637974,598070,501745,945896,267489,750330,193654,118222,135624,267532,445433,795361,515082,816622,827193,69033,836498,28148,2240,908890,397428,673,176474,902484,559824,88667,126356,823684,415424,1007059,215558,272060,860607,566055,167599) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000937s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118634 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118634 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]