SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683327 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683327 [ RunTime:0.001469s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (284630,436859,803431,676168,366260,438787,10187,550951,442482,909189,933529,547109,809651,295471,546642,953237,331948,602131,426310,406623,649247,824773,533030,769832,980769,120780,928399,153568,364082,74970,453333,90515,1018955,304969,201651,254218,485131,915743,554020,380181,292098,302015,986411,906362,1034859,115448,33242,547640,848726,602645,611614,930935,216561,531028,506367,159396,982195,394105,529860,3709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683327 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683327 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000409s ]