SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001884s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986708 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986708 [ RunTime:0.003311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (596912,394532,1008499,919792,255439,777843,878068,643650,738262,559254,1021585,158187,820683,15411,346051,531853,1040763,1028609,552112,506857,135554,551177,378420,449744,655882,1003331,745149,469018,816475,107417,703772,254422,9460,741136,178296,546570,801330,425597,971371,33950,1005912,653761,378224,389368,426740,921710,619913,437738,66867,362219,930220,867987,100877,943868,216369,802562,1006237,280659,558317,813146) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986708 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986708 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001301s ]