SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505225 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505225 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (831761,602398,377607,105322,684495,337445,545339,489423,827770,580070,158661,741964,479430,1024207,820683,826888,505252,776686,341167,482027,540776,431934,208001,714091,950273,938005,259167,371404,706747,113298,698198,322249,478580,829303,346527,592031,539647,833110,397084,221326,438150,567219,319079,818690,1009813,306818,394602,424250,165193,437317,150567,32164,887612,250045,547023,485411,616264,775968,167890,786619) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505225 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505225 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]