SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004584s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541765 LIMIT 1 [ RunTime:0.001363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541765 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (162999,1020075,784474,875293,702863,889414,583659,839430,349888,655060,374488,653249,964096,365170,27052,853173,621751,725844,149696,361198,211920,967558,889614,438956,819692,611614,177667,355244,990760,246919,154137,771009,903501,848587,97485,857912,364259,471320,275798,436501,830119,367040,506264,599302,964767,932651,974331,234078,985428,476271,813496,216169,971683,881969,194183,781374,951509,672356,203226,144462) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002674s ]