SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 422800 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 422800 [ RunTime:0.001528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156196,346156,675741,755317,428672,237363,573832,70398,549265,310884,470758,850673,204436,934980,22628,1010856,901786,318206,185315,713287,1024786,394981,10478,330329,768275,807914,150815,623746,386201,848598,160723,1041328,584789,344530,976348,344619,546543,209391,2662,351887,295835,803174,195834,13568,185761,916485,512033,600175,832589,731903,461824,454176,1010422,428255,557264,952734,978678,64707,223702,156538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 422800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 422800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001137s ]