SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003096s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481293 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481293 [ RunTime:0.001633s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (109721,716971,458839,816892,326407,320585,947553,799507,176301,19767,934848,8722,133019,872093,990362,99442,994396,269922,31108,250169,464937,492054,733662,326278,455260,229157,628633,897153,727694,208380,382867,16194,63135,132326,876502,857454,283352,994177,332265,1005159,116786,210592,494162,400960,504442,720856,318164,889954,407742,820551,15237,62567,606115,929445,159112,1030357,955171,146095,380728,503547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481293 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481293 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]