SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200536 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200536 [ RunTime:0.001608s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1013580,720796,260248,793318,50936,684981,873893,54429,37166,1009367,229281,487395,591020,481455,24384,575232,951508,754842,877860,120198,780005,723220,563822,742855,988969,807920,808071,944466,667683,161237,288706,464990,331300,524373,718138,521595,346004,268351,30291,526035,389814,593189,659526,422476,321982,939975,24566,110970,374639,121082,794362,171447,1037899,149166,789245,596136,834100,403313,828126,933487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200536 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200536 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]