SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1015438 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1015438 [ RunTime:0.001411s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (45328,966115,868280,402171,980689,339368,411338,884014,234202,425084,760903,880603,1034441,137347,175515,858471,907499,836949,670994,532569,125635,496502,1018025,506354,869389,883228,674427,874417,440412,842384,987211,575918,872382,572529,382553,242062,627309,922430,101618,801993,564964,178824,37600,253317,324608,890484,871571,135839,274648,558153,567391,976067,452289,522021,815365,534093,626278,334013,677763,188634) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1015438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1015438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]