SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002072s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413613 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413613 [ RunTime:0.001890s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28725,490742,51307,671447,288097,368739,798976,974702,237214,971905,333555,989750,446555,202253,79520,412138,711616,789424,558871,320648,650074,1013188,45207,381912,99420,966124,483477,655075,952630,820055,762950,8418,456176,122990,891919,837096,586662,944805,705482,532982,1040413,815109,170647,758530,24728,696596,1023619,865141,679812,656038,561741,360374,951887,471837,635952,144592,366603,119918,397672,531762) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003228s ]