SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48470 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48470 [ RunTime:0.001662s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573853,517832,202280,858138,237165,845721,719058,1009387,53002,157135,754567,1011586,602368,630102,1520,138946,507030,392653,410652,126930,55908,273328,208304,550240,748293,478138,325923,20278,784914,875707,135952,468160,46453,786523,447623,739762,140069,192737,582709,728101,336752,886782,771941,1046532,197731,642307,47357,484193,586996,79520,270971,578864,780649,670513,903077,581632,238188,582105,1026129,646538) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002154s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48470 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48470 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]