SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 711118 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 711118 [ RunTime:0.001568s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (557500,110816,730622,181300,58101,878024,722555,960167,605277,235773,472421,299618,141126,909342,118239,357115,219979,321403,785142,175264,12451,152769,993425,405309,644755,657064,511394,162555,596091,393383,624043,955783,217195,1020019,165881,458018,190661,108607,592977,873981,573032,845918,543285,309089,1028962,1038137,338110,660608,737891,775416,69072,524670,344556,641431,626986,96656,1042099,327896,990737,705871) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 711118 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 711118 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]