SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 433179 LIMIT 1 [ RunTime:0.000457s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 433179 [ RunTime:0.002906s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220029,949821,304850,918516,593787,352530,55960,795442,354260,505121,524501,684050,654228,412463,293327,463098,169899,410847,860036,885674,1024011,499977,923047,700839,362942,329111,239280,845735,14477,109189,207648,482359,607946,181713,777616,556601,643429,360745,241846,209037,175064,547527,635190,913138,140361,177461,810981,146044,316613,263377,146378,212701,373548,910150,407847,544226,662675,726152,373485,480199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 433179 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000892s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 433179 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]