SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401988 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401988 [ RunTime:0.002077s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181894,652650,470253,447336,630588,406072,556748,449203,951294,785789,322013,374188,242293,958525,615012,577477,178620,881095,252231,720531,153579,869727,161361,537070,439406,58786,224684,1018430,166972,548441,411577,512743,65705,639147,115228,965965,896076,405226,519252,425363,531828,798427,253964,312556,693558,705665,104247,512271,1022108,448490,58182,208106,232588,916949,708215,430010,107920,345903,362835,973304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001055s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401988 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401988 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000691s ]