SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901183 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901183 [ RunTime:0.002499s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538494,848351,942338,59635,689233,185535,278744,773736,690543,290145,92151,855331,723128,774410,877050,19003,7274,997246,108561,830219,149935,920048,576564,776973,967911,311552,602018,1002968,330836,46245,1038229,88700,699128,351963,676535,770786,359405,783312,454764,819401,275222,52136,100575,969691,110548,721183,245374,866259,561836,543004,122159,359007,1044919,426461,1045473,254407,784937,547802,808291,782898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001076s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901183 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901183 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000461s ]