SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483743 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483743 [ RunTime:0.001553s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24365,415167,340196,708510,201495,704737,681776,304619,145876,539158,622789,581754,497941,137004,1035303,761933,411372,1034450,19413,730364,293149,476260,81958,141262,937077,865406,774766,90231,829069,929830,679476,950129,643599,945845,96135,261982,802175,569787,134091,387122,955415,762595,561345,223919,213619,733457,714196,484110,730860,648465,646693,341456,526541,661197,496471,62904,493071,947859,1018794,317255) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]