SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001853s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310532 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310532 [ RunTime:0.001737s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12720,853700,461673,900812,405078,627743,49967,131720,659266,155388,232765,691024,838266,26418,638997,911067,109865,754133,402314,742638,586247,218547,774887,612028,605918,831347,396720,126357,697240,977695,121684,601104,444788,795864,287729,377494,476700,475149,663951,505164,279795,586272,26696,419942,375454,148876,193260,197777,924902,366999,79751,1025033,349870,42732,416453,817418,522531,856983,684391,260394) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001776s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310532 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310532 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001317s ]