SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861743 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861743 [ RunTime:0.001782s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (841399,220770,241076,918471,16258,737311,790842,131586,426858,152819,572925,911981,621169,435406,634008,168555,601343,364438,400772,676466,334499,937226,248890,951992,61629,1003137,869283,422929,414074,194572,175940,997403,274490,859341,36080,667889,164879,762300,515597,285589,974942,11517,437287,428634,908882,390400,688416,932361,258250,528926,85031,667601,232823,79213,135535,282968,210481,877348,207106,538946) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000696s ]