SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017011 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017011 [ RunTime:0.001841s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820846,730147,930736,241212,499717,770752,495057,921035,244151,97209,846039,880499,1023040,708021,533017,836019,422241,611391,77851,188540,448260,232438,1023841,733824,512510,449530,175986,183833,929998,182277,838635,358833,1034883,522589,192419,802459,439510,896451,722840,560235,465966,951601,106858,412227,779069,457258,431901,605035,1036006,172062,982148,676001,756041,633723,709688,75189,1002715,247283,348259,278998) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000436s ]