SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411994 LIMIT 1 [ RunTime:0.000984s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411994 [ RunTime:0.003040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78098,580066,923189,397159,977938,82685,549219,407616,403451,662167,308885,22607,500028,841306,930359,242577,266479,716388,449461,405018,673163,177549,652092,872970,697400,535409,923674,873626,270398,986086,1022484,738273,18714,580006,198345,567178,837454,149759,637196,975723,902196,578214,863602,647219,306756,861226,946771,350305,370105,481434,146511,693696,95845,94580,861518,972422,175373,138077,16776,110484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411994 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411994 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000382s ]