SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981012 LIMIT 1 [ RunTime:0.000385s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981012 [ RunTime:0.001977s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (165567,455658,819238,446195,821613,291337,568053,783950,318564,661750,802346,802585,573050,146141,320074,644637,362808,54069,566696,684864,246479,401963,218910,494024,377242,93698,13362,679780,730696,699361,584235,316298,201242,724233,766871,358448,89933,237680,98844,565204,540692,320502,763351,49223,122335,1036294,934169,134959,470821,845280,917931,930372,442843,287958,203370,807128,169406,533591,334862,966693) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981012 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981012 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]