SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524836 LIMIT 1 [ RunTime:0.000282s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524836 [ RunTime:0.002121s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478043,827106,652634,807319,338230,573333,995522,544832,632378,1023574,334828,596729,290819,358688,99227,59872,249224,791516,683870,730648,937162,1011156,208137,189152,992527,172769,894160,524397,823873,270474,212279,709256,772572,126854,403911,807457,155931,302734,36534,226842,1030351,431896,644648,1010912,154020,82199,1039227,1045207,145597,514361,681976,475069,848609,1003469,777034,238353,691821,234015,743399,472932) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]