SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 866804 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 866804 [ RunTime:0.001858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314383,149491,1018890,1013362,998450,683791,437633,307955,471601,338492,337907,1042020,840365,61798,69753,571506,886768,638977,660411,187172,290998,502324,604380,473927,841804,901126,140192,26060,106889,273938,590687,750470,747634,300178,211038,1031904,81856,484461,221168,478894,882500,135546,638001,799835,819314,958710,622524,587908,543204,921723,797410,775391,35635,17662,479478,289809,49170,121753,397106,672328) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 866804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 866804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]