SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 391643 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 391643 [ RunTime:0.002289s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (594271,863558,516481,220780,458259,1046141,223322,824050,133684,42885,872174,950196,585534,985222,904334,835710,613390,937065,898037,977924,192952,992858,1013055,893680,471141,92738,199999,411460,498692,801722,147819,220007,512384,46907,606796,429449,533725,1025209,573391,439343,903875,341836,838180,942558,822202,640959,1026051,549630,418023,496498,528520,839298,388838,906718,325583,724987,1020619,158765,820407,899721) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 391643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 391643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]