SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 109281 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 109281 [ RunTime:0.001946s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12255,873302,999147,848383,703794,520821,819682,100443,35054,81769,643274,378441,124400,868995,513741,646027,426454,853478,225207,970011,26933,634819,545998,609196,858620,922546,622340,919726,6175,640468,978036,216479,20652,353132,987843,91360,73402,763335,1019333,545172,813966,69368,748083,589878,966169,968861,150120,950692,501309,360084,751212,983823,267520,1024419,389147,89782,103400,463849,621972,290118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 109281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 109281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]