SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312691 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312691 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482304,549405,578732,388613,414922,634788,271616,62010,672228,790609,856825,956304,197304,196966,72007,683243,734789,660737,663342,195377,263216,709727,998781,919993,243801,550724,356384,215423,629462,206921,421252,70124,367690,208006,300094,71390,427182,662355,857527,372203,284151,75452,821107,750287,442369,268161,248187,816827,740188,864538,451460,462001,1022048,904423,697245,252999,592440,779160,31681,380598) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]