SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001360s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489037 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489037 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477181,794870,682563,146182,753664,508766,145519,660158,112081,93367,509808,157387,597514,491791,504849,912080,325453,581211,283071,492592,177783,660714,810584,179628,95950,700135,502269,56841,890511,702973,170224,572298,537213,705370,1047428,839473,932836,427510,109205,352333,613585,25143,387707,297575,541917,961709,733634,54385,212736,952964,481922,433784,891582,900454,782096,33964,808396,474000,580974,289305) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000711s ]