SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 381864 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 381864 [ RunTime:0.002770s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (172256,681752,739328,890475,504596,102012,644814,997785,34147,328805,497148,143781,290749,310207,88728,686650,90895,372112,616165,797425,611743,281049,264958,112163,355163,137140,322649,992843,779291,807861,957032,709652,447597,798490,141108,980782,439858,332582,1033217,807894,357212,895456,464403,321331,138836,806243,896494,775346,915545,849113,864221,847109,956938,161881,940454,686966,893265,714790,116978,328451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 381864 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 381864 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000446s ]